Oracle - Optimize import/export processes

December 2016






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.

Related :

This document entitled « Oracle - Optimize import/export processes » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.