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?
First of all, why are you using SYS to do an import? That is a clear sign you have failed to read the documentation. It's right at the top of Data Pump Import in the Utilities guide:
Do not invoke Import as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users.
Second, how did you create the SYSTEM tablespace? Whatever is imported from a source system to a target system, with respect to SYS and SYSTEM objects, and with SYSTEM allowed to autoextend - you should never see this problem in the first place.