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

Last updated on NOVEMBER 28, 2016

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.
***Checked for relevance on 09-Jun-2015***

Symptoms

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

D:\work>impdp tc_exp/tc_exp directory=my_dir dumpfile=expdp_tc.dmp logfile=expdp_tc.log schemas=tc

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 "TC_EXP"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "TC_EXP"."SYS_IMPORT_SCHEMA_01":  tc_exp/******** directory=my_dir dumpfile=expdp_tc.dmp logfile=expdp_tc.log schemas=tc
Processing object type SCHEMA_EXPORT/USER
ORA-31685: Object type USER:"TC" failed due to insufficient privileges. Failing sql is:
 CREATE USER "TC" IDENTIFIED BY VALUES 'S:910E38C4D4FD20278E715F7237C3AE737562D849A44F2693A5AC43683C85;121DE9901D08DEB1' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
ORA-31685: Object type SYSTEM_GRANT:"TC" failed due to insufficient privileges. Failing sql is:
GRANT CREATE TABLE TO "TC"
...

 and

$ impdp system/manager directory=my_dir dumpfile=expdp_tc.dmp logfile=expdp_tc.log remap_schema=tc:tc1

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.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms