RE: ORACLE WITH MYSQL DB

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 02 Sep 2004 00:58:12 -0700

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

Other related posts: