impdp的ORA-39125

Impdp时出现如下错误，感觉虽然没有影响使用，还是对这个问题探索下。
　　Starting “CESHI”.”SYS_IMPORT_FULL_02″: ceshi/******** directory=back dumpfile=20120912_zebra.dmp logfile=impdp.log remap_schema=zebra:ceshi
　　Processing object type SCHEMA_EXPORT/USER
　　ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [TABLE_STATISTICS]
　　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 105
　　ORA-06512: at “SYS.KUPW$WORKER”, line 6241
　　—– PL/SQL Call Stack —–
　　object line object
　　handle number name
　　0xdd5fc5c0 14916 package body SYS.KUPW$WORKER
　　0xdd5fc5c0 6300 package body SYS.KUPW$WORKER
　　0xdd5fc5c0 12279 package body SYS.KUPW$WORKER
　　0xdd5fc5c0 3279 package body SYS.KUPW$WORKER
　　0xdd5fc5c0 6889 package body SYS.KUPW$WORKER
　　0xdd5fc5c0 1262 package body SYS.KUPW$WORKER
　　0xdd49f6d8 2 anonymous block
　　Job “CESHI”.”SYS_IMPORT_FULL_02″ stopped due to fatal error at 09:40:01
　　查看metlink给出的解释：
　　Oracle Server – Standard Edition – Version: 10.1.0.3 to 11.2.0.2 – Release: 10.1 to 11.2
　　malformed
　　Cause
　　The statistics included in the import may be malformed.
　　Solution
　　To workaround this issue, repeat either the expdp or the impdp using the parameter EXCLUDE=STATISTICS. After import, regather the statistics for the imported objects in the target database using the DBMS_STATS package.
　　解决办法是略去statistics统计信息再次导入，metalink并没有给出是bug说法，如果后面报的的trigger方面，可能是个bug
　　，然后删除用户后再次导入还是报错,增加exclude=statistics后没有出现此类错误，怀疑是原dmp文件统计信息存在问题导致。[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25362835/viewspace-1059511/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25362835/viewspace-1059511/