What size of the table in Gigabytes?
There is an issue with moving data from Oracle into non-Oracle environment when a lot of data has to be exported into ASCII format.
I could highly recommend to consider Fastreader
http://www.wisdomforce.com. It is high speed Oracle data copy solution that is capable to extract data into ASCII and creates loader for MySQL. Depending on your Oracle hardware configuration Fastreader could export data into text with speed 5 Gigabytes or even per minute. The trick is to use direct path unload in fastreader.
With such speed the terabyte of data could be extracted in hour or so.
I did not see any other tool that comes even close to that
Vadim Wrote:
-------------------------------------------------------
> Hello,
>
> I need to routinely (i.e. monthly) copy large
> table (20 million rows, 30 columns) from Oracle to
> MySql. I tried to write Perl, Java code, but it
> takes a few days to copu the data. MySql
> migration toolbox is even longer.
>
> Any recommendations on what can I used for
> reasonable coping of the large amount of data from
> Oracle to MySql?
>
> Thanks,
>
> Vadim