ITPub博客

首页 > 数据库 > Oracle > impdp的ORA-39125

impdp的ORA-39125

原创 Oracle 作者:dotaddjj 时间:2012-09-27 16:45:06 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/25362835/viewspace-1059511/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
  • 博文量
    220
  • 访问量
    1662970