Originally posted by adewri
No need to drop the default tablespaces. Just import with ignore=y option.
IGNORE=Y has nothing to do with overwriting datafiles during the import.
Newbie, you don't have to drop your tablespaces before the import, just import with option DESTROY=N, which btw is also the default value for this parameter. DESTROY tells whether imp should overwrite the existing database datafiles (in other words, if it will recreate the existing tablespaces with the same names) during the import with FULL=Y.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?