IMPDP - ORA-31685 (Object Type USER:"<USERNAME>" Failed Due To Insufficient Privileges)
(Doc ID 1568333.1)
Last updated on APRIL 17, 2023
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>"
...
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.
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 |