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
6436
November 05, 2004 04:28PM
8259
November 16, 2004 06:39PM
3721
November 17, 2004 07:55AM
3589
November 17, 2004 10:02AM
3281
November 17, 2004 01:15PM
6674
November 17, 2004 01:46PM
2973
November 17, 2004 02:18PM
3212
November 17, 2004 02:41PM
2758
November 17, 2004 03:09PM
3310
December 08, 2004 04:01PM
3078
December 14, 2004 09:20AM
3139
December 14, 2004 09:27AM
3361
December 14, 2004 08:52PM
6661
t p
July 04, 2006 04:46PM
2976
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.