Oracle - Optimize import/export processes
Optimizing the performance of the Import/Export
- Make use of "commit = y"
- Adjust the buffer size needed to « BUFFER=.... »
- Note that its recommended that you disable the triggers, constraints and remove the index prior to import and recreate them after loading
- Break down the export into multiple files (eg a script for each user). Then import them in parallel.
Published by jak58
Latest update on May 16, 2010 at 05:32 AM by jak58.