My quick suggestion for such a process would be to use SQL*NET formatting commands to create a well-formed CSV file, which you then import into MySQL using LOAD DATA INFILE.
I'm not aware of any Oracle-specific import tools in MySQL. If anything, after the merger I would rather expect something that goes the other way round :-) On Thu, Nov 11, 2010 at 7:46 AM, Machiel Richards <machi...@rdc.co.za>wrote: > Good day all > > I am hoping that someone has got some more answers for me on the > topic as most of the websites which have not been very useful. > > All websites I have found thus far reffers to software that either > needs to be bought or otherwise need to be run manually. > > > One of our clients are currently running MySQL for their web based > systems, however all other systems are running oracle. > > There is a current "data load" process from oracle that generates a > dump file of specific data, goes through a convertion process, gets > imported into a mysql runnign on VM to test import, then gets pushed to > MySQL production. > > This process was put in place quite some time ago by developers. > > At some stage I read something about this process not being > required from MySQL 5 onwards and data imports from oracle is less > troublesome. > > > The import process needs to run every 30 minutes and the current > process is too troublesome. > > We are busy plannign a hardware migration for the systems and > are also looking at improving these processes. > > Does anybody have experience with this to perhaps provide me > with some info on how we can improve this import process? > > Any assistance will be appreciated. > > Regards > Machiel > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel