RE: ORACLE WITH MYSQL DB

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_at_askddbc.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Seema Singh
> Sent: Wednesday, September 01, 2004 3:46 PM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org put
> 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
> ----------------------------------------------------------------
> To unsubscribe send an email to: oracle-l-request_at_freelists.org
> and put 'unsubscribe' in the subject line.
> ----------------------------------------------------------------

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004