impdp minimum right for the import

Oct 28, 2019 5:31PM

Hello,

Oracle 11 vanilla

When I try to do impdp I am getting following:

impdp RESTORE/PASS@orcltest directory=DP_DIR DUMPFILE=expdp.dmp LOGFILE=impdp.log tables=CUSTOMER.DOCS,CUSTOMER.FILES REMAP_SCHEMA=CUSTOMER:RESTORE REMAP_TABLESPACE=CUSTTBS:RESTORETBS;

Import: Release 11.2.0.4.0 - Production on Mon Oct 28 22:21:57 2019

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

ORA-31626: job does not exist

ORA-31633: unable to create master table "restore.SYS_IMPORT_TABLE_05"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT", line 1038

ORA-01031: insufficient privileges

I created user as follows:

Database Administration (MOSC)

impdp minimum right for the import

Howdy, Stranger!

Category Leaderboard

Top contributors this month