ORA-01950 on Import from 9 to 11. Question
Ok I exported a number of schemas from a version 9 database, logged in as SYSTEM, using the OWNER parameter of EXP.
I then create a new version 11 database, create the same tablespaces that the version 9 database had, and then do the import using FULL=Y, again logged in as SYSTEM.
The first thing it says is :
Importing SYSTEM's objects into SYSTEM
Question - WHY ?
I didn't specify SYSTEM in the list of owners when I did the export. I didn't want to export or import Systems objects - is there any way I can avoid this ?
Next, once the import is under way, I get an error :
ORA-01950: no privileges on tablespace *****
Now, as far as I can tell, I can get around this by granting UNLIMITED TABLESPACE to the the user that will own whatever table is being built at the point the error is caused.
2nd question then - how am I meant to know ?
Surely I shouldn't have to grant UNLIMITED TABLESPACE to all users just to get an import to work ??
Anyone ?
Thanks!
Scott