Gathering Tablespace Info required while Importing Dump
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Gathering Tablespace Info required while Importing Dump

  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Post Gathering Tablespace Info required while Importing Dump

    My Question is like - let's say we received a dump file from Production or somewhere outside to deploy it locally.

    At the first attempt of import if some of the tables are not imported saying "Tablespace does not Exists". So for this we need to recreate the required tablespace and then again need to import only those selected tables or entire dump once again conditionally. But the same will be very time consuming if we receive a big dump file and we received the Exception for tablespace probably after 60% successfully import for the remaining table. In this case most of the peoples used to terminate the import, create the required tablespace referring import log and then re initiate the import process from the beginning.

    Is there any work around to handle this. Or any helpful feature in 10G which can also export/import all the tablespaces required by the objects containing in the dump.

    Any help or comments will be appreciable.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    create the tablespaces before then or user ignore=y and the tables will go into the users default tablespace

    have you read the manuals for exp and imp?

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