Oracle - Optimize import/export processes

October 2017






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.
This document, titled "Oracle - Optimize import/export processes," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).