-
Full database import
When doing full database import, Oracle will also create all the tablespace using the original file structure. If the server I am importint into does not have the same file structure, import fails. Do you have a good work around to tell Import not to use the old file structure?
-
Precreate the tablespace as you like it, and use ignore=Y option in imp.
Tamil
-
Be careful in using ignore=Y option.
Precreating tablespaces should solve your problem without any ignore=Y option(by default it is N).
-
indexfile
You could always use the indexfile option, this way you could get all of you DDL statements. You could then create them in the new tablespaces you wanted then use the ignore=y option
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
|