Road To OCM
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment