impdp时ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]

古城微笑少年丶 2022-05-29 09:00 275阅读 0赞

今天在利用impdp导入数据的时候，遇到了如下的报错信息，导致导入失败

ORA-06502: PL/SQL: numeric or value error
    LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPW$WORKER", line 9715
    ----- PL/SQL Call Stack -----
      object      line  object
      handle    number  name
    0x1cc867b18     21979  package body SYS.KUPW$WORKER
    0x1cc867b18      9742  package body SYS.KUPW$WORKER
    0x1cc867b18     17950  package body SYS.KUPW$WORKER
    0x1cc867b18      4058  package body SYS.KUPW$WORKER
    0x1cc867b18     10450  package body SYS.KUPW$WORKER
    0x1cc867b18      1824  package body SYS.KUPW$WORKER
    0x1cc5a1bd0         2  anonymous block
    ORA-39097: Data Pump job encountered unexpected error -1427
    ORA-39065: unexpected master process exception in DISPATCH
    ORA-01427: single-row subquery returns more than one row
    Job "CLOUDPIG"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at Tue Mar 20 20:26:38 2018 elapsed 0 00:24:11

查看MOS：文档 ID 878626.1

![Image 1][]

上面给出2种解决的办法：1.打补丁 2. 在impdp的时候过滤掉统计值：EXCLUDE=STATISTICS

于是采用第二种方法，在impdp 后面加上EXCLUDE=STATISTICS

![Image 1][]

最终导入成功，记住导入完成的时候别忘了手动收集下统计信息

execute dbms_stats.gather_schema_stats(ownname=>'xxxx')

[Image 1]: