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.