DataPump Import Fails With ORA-31625 / ORA-01031 in 12.2 When Importing a Common Schema With REMAP_SCHEMA Into A Multitenant Database With Data Vault Enabled (Doc ID 2301722.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On a Oracle 12c Release 2 database with Data Vault enabled, an error is received when using Oracle Data Pump to import a common user schema using remap_schema to another common user schema:

Import: Release 12.2.0.1.0 - Production on Tue Jun 13 12:05:10 2017

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
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/********@orcl schemas=c##user1 remap_schema=c##user1:c##FRAME_user2 directory=dpump_dir dumpfile=dumpfile.dmp logfile=dumpfile.log
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema C##FRAME_COHENA_90 is needed to import this object, but is unaccessible
ORA-01031: insufficient privileges

Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'53109845');COMMIT; END;

 
The 'C##' prefix indicates that these are common users, i.e. they exist and have privileges across multiple PDBs.

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