Oracle Error:ORA-39126:Worker unexpected fatal ...

2019独角兽企业重金招聘Python工程师标准>>>

在使用impdp导入数据时发生了如下错误：

$ impdp userid=\'/ as sysdba\'directory=dirdp1 DUMPFILE=xxx_UAT_121108.dmp SQLFILE=xxx_UAT121108.sql

Import: Release 11.2.0.1.0 - Production on Thu Nov 8 17:08:58 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SYS"."SYS_SQL_FILE_FULL_03" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_03":  userid="/******** AS SYSDBA"directory=dirdp1 DUMPFILE=xxx_UAT_121108.dmp SQLFILE=xxx_UAT121108.sql 
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [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 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xb7aafa70     19028  package body SYS.KUPW$WORKER
0xb7aafa70      8191  package body SYS.KUPW$WORKER
0xb7aafa70     15631  package body SYS.KUPW$WORKER
0xb7aafa70      3944  package body SYS.KUPW$WORKER
0xb7aafa70      4705  package body SYS.KUPW$WORKER
0xb7aafa70      8916  package body SYS.KUPW$WORKER
0xb7aafa70      1651  package body SYS.KUPW$WORKER
0xc18aed48         2  anonymous block

Job "SYS"."SYS_SQL_FILE_FULL_03" stopped due to fatal error at 17:09:01

文档ID 878626.1描述了发生此错误的原因与解决方法：

Applies to:
Oracle Server - Standard Edition - Version: 10.1.0.3 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-SEP-2011***

Symptoms
DataPump import terminates with the following errors in the import log file:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [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"
ORA-06512: at "SYS.KUPW$WORKER"

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.

加入所示参数后，重新执行后：

$ impdp userid=\'/ as sysdba\'directory=dirdp1 DUMPFILE=xxx_UAT_121108.dmp SQLFILE=xxx_UAT121108.sql EXCLUDE=STATISTICS

转载于:https://my.oschina.net/liuliufa/blog/87937