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
6466
November 05, 2004 04:28PM
8271
November 16, 2004 06:39PM
3732
November 17, 2004 07:55AM
3602
November 17, 2004 10:02AM
3302
November 17, 2004 01:15PM
6704
November 17, 2004 01:46PM
2987
November 17, 2004 02:18PM
3230
November 17, 2004 02:41PM
2772
November 17, 2004 03:09PM
3324
December 08, 2004 04:01PM
3093
December 14, 2004 09:20AM
3150
December 14, 2004 09:27AM
3371
December 14, 2004 08:52PM
6673
July 04, 2006 04:46PM
3624
July 04, 2006 05:02PM
2986
July 06, 2006 03:37PM
3454
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.