Re: Linking Oracle tables to MySQL
Josh,
Here is kind of what I am doing now.
From the Oracle/UNIX server side I execute a script using ssh to on the MySQL/linux server to create a text file uising filtered data and only 90 days old. THis is about 4000 record now. The text files is FTPed back to the Oracle server and loaded into a temp table. At this point the data from the MySQL database can be linked to the Oracle data to update 50 records or so.
The whole process as it stands is take only 2-3 minutes.
While typing this I had another thought.
When I execute the script I could be passing a list of SalesOrderNo to the MySQL server and load them into a temp table and use them for a filter to get my test data to pass back to Oracle.
The Data on the MySql side is time stamped and there is othe feilds I can use to linit the amount of data I need to send back to Oracle. Right now 90 days is the best I can do.
I was just trying to find a better way to do this.
Subject
Views
Written By
Posted
6587
November 05, 2004 04:28PM
8363
November 16, 2004 06:39PM
3781
November 17, 2004 07:55AM
3656
November 17, 2004 10:02AM
Re: Linking Oracle tables to MySQL
3363
November 17, 2004 01:15PM
6793
November 17, 2004 01:46PM
3043
November 17, 2004 02:18PM
3311
November 17, 2004 02:41PM
2827
November 17, 2004 03:09PM
3380
December 08, 2004 04:01PM
3139
December 14, 2004 09:20AM
3204
December 14, 2004 09:27AM
3420
December 14, 2004 08:52PM
6741
July 04, 2006 04:46PM
3681
July 04, 2006 05:02PM
3037
July 06, 2006 03:37PM
3529
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.