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
On Thu, Nov 11, 2010 at 7:46 AM, Machiel Richards <machielr@stripped>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
> 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.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel