Hi,
I received a pump file from a colleague which he exported using expdp.
This file contains data for a PDB's user ("A").
I want to import this user's data into this user's schema on my database (ie. "A:A"), but I don't want to give this user all the rights required to do so.
In my pluggable database I'm having a user ("B") with DBA privileges in the PDB. I want this user to perform the import. But it fails:
Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "B.SYS_IMPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-01950: no privileges on tablespace 'SYSTEM'
ORA-06512: at "SYS.KUPV$FT", line 1035
ORA-06512: at "SYS.KUPV$FT", line 1023
What do I need to do to be able to import data from "A" into "A"'s scheme on my database while being logged in as user "B"?
Your help is very much appreciated.