DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Import 1GB dmp file to a new server

  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Question

    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

  2. #2
    Join Date
    May 2002
    Posts
    193
    Create a large rollback segment and use that rollback segment for the import. This will bring down the time for import..

    Regards,

    K.Diwakar

  3. #3
    Join Date
    Apr 2002
    Posts
    14
    How much big it has to be? I mean 1 GB or more?
    My import file is about 1GB.
    Thanks for your answer.
    Franco

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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.

  5. #5
    Join Date
    Apr 2002
    Posts
    14

    Thumbs up

    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
  •  


Click Here to Expand Forum to Full Width