Originally posted by jmodic
All you need is a SYSTEM tablespace (which you allways have if you have a database). Nothing else, no other tablespaces are neccessary for the import with FULL=Y to succeed. And it will create all other tablespaces for you too. Of course for this to succeed the directory structure for the database files in the new system must be existing and the same as it was in the exported system.
Hello, first, thanks for your help, so if my 9i DB has all the preconfigured tablespaces like TEMP,USERS, TOOL..etc do I need to drop them first since during the import full=y process, Oracle will try to create these tablespaces. Please advise. Thanks again