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.
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?
Click Here to Expand Forum to Full Width