ORA-39013: Remapping the SYSTEM schema is not supported.

Scenario : Took Data Pump Export of SYSTEM schema in Oracle 12c CDB container database and tried to import that backup dumpfile data inside a Pluggable database PDBTEST but it ends with an error saying "Remapping SYSTEM is not supported."


Let's take a look.
----------------

1 - Export the Oracle 12c CDB SYSTEM schemas as below.


E:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN>expdp system/redhat directory=system_dir dumpfile=system.dmp logfile=system.log

Export: Release 12.1.0.1.0 - Production on Thu May 19 13:53:56 2016

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=system_dir dumpfile=system.dmp logfile=system.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
  C:\SYSTEM_DIR\SYSTEM.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu May 19 13:54:32 2016 elapsed 0 00:00:30





SQL> conn system/redhat@pdbtest
Connected.


SQL> show con_name

CON_NAME
------------------------------
PDBTEST


Now, let's try to import the exported SYSTEM schema from Oracle 12c CDB inside one of its PDB pluggable database names PDBTEST in schema TEST as illustrated below.
--------------------------------------------------------------------------------------------------------------

E:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN>impdp system/redhat@pdbtest directory=PDBTEST_DATA_PUMP_DIR dumpfile=system.dmp logfile=test.log remap_schema=system:test

Import: Release 12.1.0.1.0 - Production on Thu May 19 14:00:02 2016

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-39013: Remapping the SYSTEM schema is not supported.



-- Here you got the error saying Remapping the SYSTEM schema is not supported.



Solution : You can re-try the import without REMAP_SCHEMA clause as illustrated below.


E:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN>impdp system/redhat@pdbtest directory=PDBTEST_DATA_PUMP_DIR dumpfile=system.dmp logfile=test.log

Import: Release 12.1.0.1.0 - Production on Thu May 19 14:13:19 2016

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/********@pdbtest directory=PDBTEST_DATA_PUMP_DIR dumpfile=system.dmp logfile=test.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Thu May 19 14:13:22 2016 elapsed 0 00:00:03


Import went successful now.