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 ( 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.