Originally posted by candyman
please correct me if I am wrong. Don't you have to precreate the tablespaces first before the import??? I don't think you can do a full import without tablespaces
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.