import
Unloading data from Oracle?
dmann — Fri, 03/26/2010 - 15:42
I recently fielded a question about getting data out of Oracle quickly. Without much detail on the systems involved here is my answer:
Question:
I need to migrate data from Oracle to MySQL quickly (in less than 1 day). What are my options?My answer:
Oracle does not supply an out-of-the-box unload utility. Keep in mind without comprehensive info about your environment (oracle version? server platform? how much data? what datatypes?) everything here is YMMV and you would want to give it a go on your system for performance and timing.Oracle imp utility COMMIT parameter and LOBS…
dmann — Sun, 10/22/2006 - 21:04
If you have a lot of LOB data to move around with Oracle import/export utilities this might help you out. The default for the COMMIT parameter is No.
COMMIT=N : For tables that have a LOB column, commit is performed after loading each table
This is much faster but be aware that you will use more Rollback space since each table will be committed in one large transaction.
COMMIT=Y : For tables that have a LOB column, commit is performed after each row (slow!, much overhead added because so many transactions are used to import the data) Read more »
