IMPDP导入出现ORA-39126，ORA-31604，ORA-06512 错误

RDBMS 11.2.0.4 

使用IMPDP导入的时候，使用了remap_table参数，提示出现错误ORA-39126，ORA-31604，ORA-06512

[oracle@test ~]$ impdp bb/oracle dumpfile=dump:bb_t2.dmp logfile=dump:bbt2_imp.log remap_table=bb_t1:bb_t2 

Import: Release 11.2.0.4.0 - Production on Mon Mar 12 15:24:59 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BB"."SYS_IMPORT_FULL_05" successfully loaded/unloaded
Starting "BB"."SYS_IMPORT_FULL_05":  bb/******** dumpfile=dump:bb_t2.dmp logfile=dump:bbt2_imp.log remap_table=bb_t1:bb_t2 
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS [] 
ORA-31604: invalid transform NAME parameter "MODIFY" for object type PROCACT_INSTANCE in function ADD_TRANSFORM

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x78e1c3a0     21979  package body SYS.KUPW$WORKER
0x78e1c3a0      9742  package body SYS.KUPW$WORKER
0x78e1c3a0     15083  package body SYS.KUPW$WORKER
0x78e1c3a0     17516  package body SYS.KUPW$WORKER
0x78e1c3a0      4058  package body SYS.KUPW$WORKER
0x78e1c3a0     10450  package body SYS.KUPW$WORKER
0x78e1c3a0      1824  package body SYS.KUPW$WORKER
0x7ec79d48         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS [] 
ORA-31604: invalid transform NAME parameter "MODIFY" for object type PROCACT_INSTANCE in function ADD_TRANSFORM

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x78e1c3a0     21979  package body SYS.KUPW$WORKER
0x78e1c3a0      9742  package body SYS.KUPW$WORKER
0x78e1c3a0     15083  package body SYS.KUPW$WORKER
0x78e1c3a0     17516  package body SYS.KUPW$WORKER
0x78e1c3a0      4058  package body SYS.KUPW$WORKER
0x78e1c3a0     10450  package body SYS.KUPW$WORKER
0x78e1c3a0      1824  package body SYS.KUPW$WORKER
0x7ec79d48         2  anonymous block

Job "BB"."SYS_IMPORT_FULL_05" stopped due to fatal error at Mon Mar 12 15:25:02 2018 elapsed 0 00:00:03

解决方法，碰到bug了，参考MOS ：1596495.1

SOLUTION

At the time of writing there was no patch available. You can workaround the issue by specifying exclude=PROCACT_INSTANCE.

To implement the fix, please execute the following step:

• Use an additional parameter that is exclude=PROCACT_INSTANCE during impdp
  
  - OR -
  
  
• Redo the export with exclude=PROCACT_INSTANCE and perform import using new dumpfiles.

The use of the exclude=PROCACT_SYSTEM will exclude the resource manager objects such as resource plans and groups.
That means that if you had resource plans and groups, you will need to recreate them after the import. 

再次导入，

[oracle@test ~]$ impdp bb/oracle dumpfile=dump:bb_t1.dmp logfile=dump:bb_t1_imp1.log REMAP_TABLE=bb_t1:bb_t3  exclude=PROCACT_INSTANCE

Import: Release 11.2.0.4.0 - Production on Mon Mar 12 15:36:52 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BB"."SYS_IMPORT_FULL_06" successfully loaded/unloaded
Starting "BB"."SYS_IMPORT_FULL_06":  bb/******** dumpfile=dump:bb_t1.dmp logfile=dump:bb_t1_imp1.log REMAP_TABLE=bb_t1:bb_t3 exclude=PROCACT_INSTANCE 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "BB"."BB_T3"                                540.6 MB 5581504 rows
Job "BB"."SYS_IMPORT_FULL_06" successfully completed at Mon Mar 12 15:38:14 2018 elapsed 0 00:01:21

[oracle@test ~]$ df -h

End 。