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?
12-16-2005, 04:17 PM
Precreate the tablespace as you like it, and use ignore=Y option in imp.
12-18-2005, 12:45 AM
Be careful in using ignore=Y option.
Precreating tablespaces should solve your problem without any ignore=Y option(by default it is N).
12-18-2005, 05:48 PM
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