Does anyone know the fastest way to export a table from Oracle to mysql? I'm currently doing it via ADO and Oracle OCI calls but for a table consisting of ~139 million records, it takes around 14 hours. Is there a way to do a dump from Oracle and then import the dump file (csv, etc...) into mysql? I know how to do the mysql csv import, it's the Oracle export I'm having trouble with. Using Oracle 8.0.5.

- Future thanks.

-- Damon