Saturday, May 26, 2012

Minimise redo log generation during import in Oracle 9i

  • Use direct path
  • Import without the indexes (use indexes=NO)
  • Create the index script file (with indexfile=indexscript.sql)
  • Modify the index script file to add NOLOGGING to the CREATE INDEX statements
  • Run the index script file
 That way you avoid Logging on the indexes at least.

No comments:

Post a Comment