I had a similar situation to communicate with a non oracle database. However, i understand that the Oracle Heterogeneous Services do not support DDLs across different databases. Our requirement was such that if a DDL takes place in Oracle the same (equivalent) had to take place in the other db too. I settled for a different solution . In this case Java i suppose looks a candidate. May be someone else in this list has a better experience. HTH GovindanK Oracle Certified Professional On Wed, 1 Sep 2004 15:50:43 -0600, "Justin Cave" <justin@xxxxxxxxxxx> said: > You can use Oracle Heterogeneous Services to create a database link to > the > MySQL database. Then, you could manipulate the MySQL data via SQL. > > > Justin Cave > Distributed Database Consulting, Inc. > http://www.ddbcinc.com/askDDBC > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Seema Singh > Sent: Wednesday, September 01, 2004 3:46 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: ORACLE WITH MYSQL DB > > Hi > How to connect Oracle database with MYSQL database? > I want to connect oracle database with MYSQL database.How to do this? > thx. > > _________________________________________________________________ > Is your PC infected? Get a FREE online computer virus scan from McAfeeR > Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put > 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > > > > ---------------------------------------------------------------- > To unsubscribe send an email to: oracle-l-request@xxxxxxxxxxxxx > and put 'unsubscribe' in the subject line. > ---------------------------------------------------------------- --- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To read recent messages - //freelists.org/archives/oracle-l/09-2004