• Impdp Fails With ORA-39126 ORA-31604 Iinvalid Transform NAME Parameter "MODIFY" For Object Type PROCACT_INSTANCE in function ADD_TRANSFORM (Doc ID 1596495.1)


    SYMPTOMS
    DataPump shows following errors :
    
    Starting "<LOGIN_SCHEMA>"."SYS_IMPORT_FULL_14":  <LOGIN>/******** parfile=<PARFILE_NAME>.par logfile=<LOG_NAME>.log dumpfile=<DUMPFILE_NAME>.dmp parallel=1
    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 8996
     
    
    CHANGES
     
    
    CAUSE
    The cause of this problem has been identified in
    Bug 16551094 - DATAPUMP IMPORT REMAP_TABLE FAILS WITH ORA-39126, ORA-31604
    
    The bug is fixed in 12c.
    
    
    SOLUTION
    Download and apply the patch 16551094 if available for your version and platform.
    
    Or
    
    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.
    

      

  • 相关阅读:
    VB程序逆向反汇编常见的函数(修改版)
    [反汇编练习] 160个CrackMe之009
    [反汇编练习] 160个CrackMe之008
    [反汇编练习] 160个CrackMe之007
    [反汇编练习] 160个CrackMe之006
    Delphi反汇编内部字符串处理函数/过程不完全列表
    [反汇编练习] 160个CrackMe之005
    [反汇编练习] 160个CrackMe之004
    新建Django配置
    mysql 常用命令大全
  • 原文地址:https://www.cnblogs.com/muzisanshi/p/13469535.html
Copyright © 2020-2023  润新知