Linking Oracle tables to MySQL
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
Subject
Views
Written By
Posted
Linking Oracle tables to MySQL
6560
November 05, 2004 04:28PM
8343
November 16, 2004 06:39PM
3770
November 17, 2004 07:55AM
3644
November 17, 2004 10:02AM
3350
November 17, 2004 01:15PM
6776
November 17, 2004 01:46PM
3026
November 17, 2004 02:18PM
3293
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
3405
December 14, 2004 08:52PM
6724
July 04, 2006 04:46PM
3667
July 04, 2006 05:02PM
3025
July 06, 2006 03:37PM
3510
July 20, 2006 11:41PM
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.