-
I have successfully exported one user from a production server and now I need to import this user to a new server for test purpose.
What is the best and the most quick way to do it?
Do I need to have a big temporary tablespace?
Is it correct to set my new server in noarchive mode just for this import?
Please let me know what are the rules.
Best regards and thank you very much.
Franco
-
Create a large rollback segment and use that rollback segment for the import. This will bring down the time for import..
Regards,
K.Diwakar
-
How much big it has to be? I mean 1 GB or more?
My import file is about 1GB.
Thanks for your answer.
Franco
-
Originally posted by franco
How much big it has to be? I mean 1 GB or more?
My import file is about 1GB.
Thanks for your answer.
Franco
if u use commit =y while importing u don't need a very big rollback segment.
-
Thank you for all your help.I have succesfully imported 1 GB dmp file to my new server via enterpise manager.
Best regards.
Franco
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
|