ORA-31625 and ORA-01031 IMPDP

<<Back to Oracle DATAPUMP Main Page

ORA-31625: Schema XXX is needed to import this object, but is unaccessible

ORA-01031: insufficient privileges

$impdp test/xxxx@pdb01 directory=exp NETWORK_LINK=exp_test logfile=exp.log
Import: Release 12.2.0.1.0 - Production on Mon Oct 29 14:26:48 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "TEST"."SYS_IMPORT_SCHEMA_01":  test/********@pdb01 directory=exp NETWORK_LINK=exp_test logfile=exp.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema TEST_EXP is needed to import this object, but is unaccessible
ORA-01031: insufficient privileges

Cause

User performing import is missing Privilege.

Solution:

Check if the appropriate role is granted to the user performing import.

SQL>  grant DATAPUMP_IMP_FULL_DATABASE to test;

Grant succeeded.

Check if the user has  become user privilege.

SQL>  grant become user to test;