|
-
Hi
To make import faster you can do
1. imp with indexs=n, this will not create indexes and make the import faster. Then u can do imp whith indexfile=index.sql, this will generate your index creation script which you can run later.
2. Create few monster rollback segments in different tablespace for the import and keep other rollback segments offline.
3. give buffer=large value. (be carefule or it will eat up your memory)
HTH
Regards
Amar
Amar
"There is a difference between knowing the path and walking the path."

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|