Faster import export Oracle

For fast export
Set the buffer parameter to high value.
use direct=y
Set recordlength parameter to high.
Make sure on which on disk u r taking export should have minimal I/O.

For fast Import
Import without indexes then use the indexfile, due to which u can skip the creation of indexes at the time of import.
Increase the size of database buffer cache and log_buffer.
Keep database in no archive mode.
Use statistics=NONE and analyze=N in import command
Set the buffer parameter value to high
Use commit=y <- menurut sikathabis tergantung kebutuhan
Point the import dump file on different disk file other than database file disk.

links: http://all-about-oracle.blogspot.com/2006/10/faster-import-export.html

Leave a Reply