-
This qst is in my head for a long long time. I decide that I'm going to find the answer(s) today.
What options would you use when you export and import database? and why?
-
-
Sorry for the vague qst. What I'm question about is the performance side of export and import. What paramters would you use to improve the export and import process? Suxh as no index while importing data? etc.
Susan
-
For data exports
DIRECT=Y
Imports,
increase the size of
BUFFER
from default of 64K. Might want to try 5MB.
OCP 8i, 9i DBA
Brisbane Australia
-
Would you consider disable the index option while importing the data as a good performance tip? If yes, you will have to import the index as the seperate process. So, what performance improvement will it be?
BTW, thank you for providing your input.
Susan
-
Susan,
I wouldn't disable it, but why don't you try the db administraton forum, there your query will be taken care of better.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Will do. I am used to log into this board lately, so I post my qst here.
Thanks.
Susan
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
|