My Oracle Support Banner

IMPDP - ORA-31685 (Object Type USER:"<USERNAME>" Failed Due To Insufficient Privileges) (Doc ID 1568333.1)

Last updated on MAY 17, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to import a schema with Import Data Pump the following errors occur:

impdp <LOGIN>/<PASSWORD> directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp logfile=<LOG_NAME>.log schemas=<SCHEMA_NAME>

Import: Release 11.2.0.3.0 - Production on Thu Jul 11 15:44:10 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "<LOGIN_SCHEMA>"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "<LOGIN_SCHEMA>"."SYS_IMPORT_SCHEMA_01":  <LOGIN>/******** directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp logfile=<LOG_NAME>.log schemas=<SCHEMA_NAME>
Processing object type SCHEMA_EXPORT/USER
ORA-31685: Object type USER:"<USERNAME>" failed due to insufficient privileges. Failing sql is:
CREATE USER "<USERNAME>" IDENTIFIED BY VALUES '<VALUE>' DEFAULT TABLESPACE "<TABLESPACE_NAME>" TEMPORARY TABLESPACE "<TEMP_TABLESPACE_NAME>"
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
ORA-31685: Object type SYSTEM_GRANT:"<USERNAME>" failed due to insufficient privileges. Failing sql is:
GRANT CREATE TABLE TO "<USERNAME>"
...

 and

$ impdp <LOGIN>/<PASSWORD> directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp logfile=<LOG_NAME>.log remap_schema=<SOURCE_SCHEMA>:<TARGET_SCHEMA>

Import: Release 11.2.0.3.0 - Production on Thu Jul 11 15:46:55 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.