本文共 1162 字，大约阅读时间需要 3 分钟。

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

ORA-06502: PL/SQL: numeric or value errorLPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPW$WORKER", line 9715----- PL/SQL Call Stack -----  object      line  object  handle    number  name0x1cc867b18     21979  package body SYS.KUPW$WORKER0x1cc867b18      9742  package body SYS.KUPW$WORKER0x1cc867b18     17950  package body SYS.KUPW$WORKER0x1cc867b18      4058  package body SYS.KUPW$WORKER0x1cc867b18     10450  package body SYS.KUPW$WORKER0x1cc867b18      1824  package body SYS.KUPW$WORKER0x1cc5a1bd0         2  anonymous blockORA-39097: Data Pump job encountered unexpected error -1427ORA-39065: unexpected master process exception in DISPATCHORA-01427: single-row subquery returns more than one rowJob "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

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

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

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

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