分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
--=======================================================
-- ORA-39126 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]错误
--=======================================================
在Oracle11g中使用impdp导入时,碰到了下列错误:ORA-39126 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]中 Worker 发生意外致命错误
如下:
impdp system/passwd directory=data_pump_dir dumpfile=nmg350627.DMP schemas=hohhot remap_schema=hohhot:hohhotnmg
logfile=imp0701.log
Import: Release 11.2.0.1.0 - Production on 星期五 7月 1 16:10:51 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "HOHHOTNMG"."SYS_IMPORT_SCHEMA_01"
启动 "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=data_pump_dir dumpfile=nmg350627.DMP
schemas=hohhot remap_schema=hohhot:hohhotnmg logfile=imp0701.log
处理对象类型 SCHEMA_EXPORT/USER
处理对象类型 SCHEMA_EXPORT/SYSTEM_GRANT
处理对象类型 SCHEMA_EXPORT/ROLE_GRANT
处理对象类型 SCHEMA_EXPORT/DEFAULT_ROLE
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/TYPE/TYPE_SPEC
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
. . 导入了 "HOHHOTNMG"."TAPP_RESOURCE" 26.30 MB 1408 行
. . 导入了 "HOHHOTNMG"."TAPP_INFO_FILE" 17.67 MB 94 行
. . 导入了 "HOHHOTNMG"."TAPP_SCHEMA_BUTTON" 6.484 MB 782 行
. . 导入了 "HOHHOTNMG"."TAPP_FINDEXQUEUE" 400.4 KB 183 行
. . 导入了 "HOHHOTNMG"."TAPP_ROLE_OBJ_PRIV" 4.430 MB 36574 行
...........
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
ORA-06502: PL/SQL: 数字或值错误
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
object line object
handle number name
33ACF770 18990 package body SYS.KUPW$WORKER
33ACF770 8192 package body SYS.KUPW$WORKER
33ACF770 15575 package body SYS.KUPW$WORKER
33ACF770 3945 package body SYS.KUPW$WORKER
33ACF770 8875 package body SYS.KUPW$WORKER
33ACF770 1649 package body SYS.KUPW$WORKER
2B712238 2 anonymous block
ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
ORA-06502: PL/SQL: 数字或值错误
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
object line object
handle number name
33ACF770 18990 package body SYS.KUPW$WORKER
33ACF770 8192 package body SYS.KUPW$WORKER
33ACF770 15575 package body SYS.KUPW$WORKER
33ACF770 3945 package body SYS.KUPW$WORKER
33ACF770 8875 package body SYS.KUPW$WORKER
33ACF770 1649 package body SYS.KUPW$WORKER
2B712238 2 anonymous block
作业 "SYSTEM"."SYS_IMPORT_SCHEMA_01" 因致命错误于 16:12:32 停止
参考metalink文档ID 878626.1
Applies to:
Oracle Server - Standard Edition - Version: 10.1.0.3 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.
DataPump Import Including Statistics Terminates With Fatal Error ORA-39126, ORA-6502, LPX-225 End-Element
Tag "HIST_GRAM_LIST_ITEM" [ID 878626.1]
-- ORA-39126 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]错误
--=======================================================
在Oracle11g中使用impdp导入时,碰到了下列错误:ORA-39126 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]中 Worker 发生意外致命错误
如下:
impdp system/passwd directory=data_pump_dir dumpfile=nmg350627.DMP schemas=hohhot remap_schema=hohhot:hohhotnmg
logfile=imp0701.log
Import: Release 11.2.0.1.0 - Production on 星期五 7月 1 16:10:51 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "HOHHOTNMG"."SYS_IMPORT_SCHEMA_01"
启动 "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=data_pump_dir dumpfile=nmg350627.DMP
schemas=hohhot remap_schema=hohhot:hohhotnmg logfile=imp0701.log
处理对象类型 SCHEMA_EXPORT/USER
处理对象类型 SCHEMA_EXPORT/SYSTEM_GRANT
处理对象类型 SCHEMA_EXPORT/ROLE_GRANT
处理对象类型 SCHEMA_EXPORT/DEFAULT_ROLE
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/TYPE/TYPE_SPEC
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
. . 导入了 "HOHHOTNMG"."TAPP_RESOURCE" 26.30 MB 1408 行
. . 导入了 "HOHHOTNMG"."TAPP_INFO_FILE" 17.67 MB 94 行
. . 导入了 "HOHHOTNMG"."TAPP_SCHEMA_BUTTON" 6.484 MB 782 行
. . 导入了 "HOHHOTNMG"."TAPP_FINDEXQUEUE" 400.4 KB 183 行
. . 导入了 "HOHHOTNMG"."TAPP_ROLE_OBJ_PRIV" 4.430 MB 36574 行
...........
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
ORA-06502: PL/SQL: 数字或值错误
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
object line object
handle number name
33ACF770 18990 package body SYS.KUPW$WORKER
33ACF770 8192 package body SYS.KUPW$WORKER
33ACF770 15575 package body SYS.KUPW$WORKER
33ACF770 3945 package body SYS.KUPW$WORKER
33ACF770 8875 package body SYS.KUPW$WORKER
33ACF770 1649 package body SYS.KUPW$WORKER
2B712238 2 anonymous block
ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
ORA-06502: PL/SQL: 数字或值错误
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
object line object
handle number name
33ACF770 18990 package body SYS.KUPW$WORKER
33ACF770 8192 package body SYS.KUPW$WORKER
33ACF770 15575 package body SYS.KUPW$WORKER
33ACF770 3945 package body SYS.KUPW$WORKER
33ACF770 8875 package body SYS.KUPW$WORKER
33ACF770 1649 package body SYS.KUPW$WORKER
2B712238 2 anonymous block
作业 "SYSTEM"."SYS_IMPORT_SCHEMA_01" 因致命错误于 16:12:32 停止
参考metalink文档ID 878626.1
Applies to:
Oracle Server - Standard Edition - Version: 10.1.0.3 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.
DataPump Import Including Statistics Terminates With Fatal Error ORA-39126, ORA-6502, LPX-225 End-Element
Tag "HIST_GRAM_LIST_ITEM" [ID 878626.1]