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, 03:17 PM
tamilselvan
Precreate the tablespace as you like it, and use ignore=Y option in imp.
Tamil
12-17-2005, 11:45 PM
sunil_kandi
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, 04:48 PM
craigdba
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