All,

I am running a full import using impdp. During the import, I run into "ORA-01536: space quota exceeded for tablespace 'SYSTEM'":

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39171: Job is experiencing a resumable wait.
ORA-01536: space quota exceeded for tablespace 'SYSTEM'

I am using "sys as sysdba" user to do this import. Sysdba is being granted with unlimited tablespace system privilege by default. I went ahead granted sys user unlimited tablespace and quota unlimited on system tablespace anyway, but still getting the errors above.

The quetion is why I am getting this error for sys user? Anyone has any insight on this, please help?


Thanks,
Unna