MySQL Forums
Forum List  »  Oracle

Linking Oracle tables to MySQL
Posted by: Marty Metras
Date: November 05, 2004 04:28PM

I us both Oracle and MySQL.
Oracle is on UNIX and MySQL is on Linux.
I have links between different Oracle database (on different servers) but not to the MySQL databases. I can do this in MS Access with ODBC but am unable to do it from UNIX Oracle & Linux MySQL.
I want to convert a program that create text data from MySQL that I import into the Oracle database to filter the data.

I want to make a direct link in the SQL to get data directlly from the MySQL database from ORACLE.

Kind of like this: Where the 2 tables are one different servers.

Select o.partno, m.partnumber
from oracle.PARTmaster_TABLE o, mysql.partmaster_table m
where o.partno = m.partmeaster;

Is there a was to directly link these to DBs?

Marty

Options: ReplyQuote


Subject
Views
Written By
Posted
Linking Oracle tables to MySQL
6561
November 05, 2004 04:28PM
8344
November 16, 2004 06:39PM
3770
November 17, 2004 07:55AM
3644
November 17, 2004 10:02AM
3350
November 17, 2004 01:15PM
6777
November 17, 2004 01:46PM
3026
November 17, 2004 02:18PM
3294
November 17, 2004 02:41PM
2814
November 17, 2004 03:09PM
3365
December 08, 2004 04:01PM
3128
December 14, 2004 09:20AM
3189
December 14, 2004 09:27AM
3406
December 14, 2004 08:52PM
6724
t p
July 04, 2006 04:46PM
3026
t p
July 06, 2006 03:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.