Originally posted by Ritchie Warsi:
Other advice is always still welcome.
edit: Oracle exp makes a dump right? As far as I know MySQL can't read/import Oracle dumps...or has this changed recently?
edit2: Nevermind, Oracle's CSV export can be read by MySQL it seems.
[ January 06, 2005: Message edited by: Ritchie Warsi ]
Hi Ritchie,
I don't know how tight is your budget for this project.
You may want to look FastReader
www.wisdomforce.com FastReader extracts large Oracle tables into flat file with any delimiter (csv type)or xml. At same time FastReader generates loaders for major databases, including MySQL. You can easily set up some automatic scripts with that. I am using FastReader to unload very large Oracle tables (tens millions of rows) into MS SQL Server. Works very well for me, fast and effective, supports most Oracle data types, including binary, blobs, cblobs, etc.