首页 >

通过数据库链导出遇到ORA-39126错误

数据库|mysql教程通过数据库链导出遇到ORA-39126错误
ORA-39126,通过数据库链导出遇到ORA-39126错
数据库-mysql教程
手机app直播网站源码,vscode右键没有跳转选项,Ubuntu结束指令,tomcat下添加端口,数据爬虫作业,织梦tags.php,平顶山seo优化教程,网站查询系统源码,html设计模板lzw
在Oracle 11.2.0.2数据库中通过NETWORK_LINK方式导出或导入10.2.0.3数据库中的表,出现了这个错误。
飘逸登录器源码,vscode切换文件插件,ubuntu文本黑屏,tomcat发布静态页面,nutch爬虫系统,php ocs,海珠seo优化托管哪家好,门户网站用什么程序做,semanticui模板下载lzw
浪漫表白网页源码,vscode向右拆分编辑器,ubuntu 桌面分屏,tomcat 找不到页面,爬虫做小程序,php聚合函数,搜索引擎营销及seolzw

在Oracle 11.2.0.2数据库中通过NETWORK_LINK方式导出或导入10.2.0.3数据库中的表,出现了这个错误。

详细错误如下:

[oracle@Oracle112 dmp]$ impdp system/password noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107;

Import: Release 11.2.0.2.0 – Production on Wed Mar 16 04:44:36 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”SYS_IMPORT_TABLE_01″: system/******** noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-00920: invalid relational operator
ORA-06512: at “SYS.DBMS_METADATA”, line 1546
ORA-06512: at “SYS.DBMS_METADATA”, line 1583
ORA-06512: at “SYS.DBMS_METADATA”, line 1891
ORA-06512: at “SYS.DBMS_METADATA”, line 3956

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8353

—– PL/SQL Call Stack —–
object line object
handle number name
0x136b50808 19208 package body SYS.KUPW$WORKER
0x136b50808 8385 package body SYS.KUPW$WORKER
0x136b50808 12748 package body SYS.KUPW$WORKER
0x136b50808 4742 package body SYS.KUPW$WORKER
0x136b50808 9110 package body SYS.KUPW$WORKER
0x136b50808 1688 package body SYS.KUPW$WORKER
0x137e37d68 2 anonymous block

Job “SYSTEM”.”SYS_IMPORT_TABLE_01″ stopped due to fatal error at 04:44:38

[oracle@Oracle112 dmp]$ expdp system/password directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107

Export: Release 11.2.0.2.0 – Production on Wed Mar 16 04:46:21 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”SYS_EXPORT_TABLE_01″: system/******** directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:”XYYZONE”.”TAB_COMM_POINTS_HISTORY”:”YMAX”]
ORA-00920: invalid relational operator
ORA-06512: at “SYS.DBMS_METADATA”, line 1546
ORA-06512: at “SYS.DBMS_METADATA”, line 1583
ORA-06512: at “SYS.DBMS_METADATA”, line 1891
ORA-06512: at “SYS.DBMS_METADATA”, line 3956

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 8358

—– PL/SQL Call Stack —–
object line object
handle number name
0x136b50808 19208 package body SYS.KUPW$WORKER
0x136b50808 8385 package body SYS.KUPW$WORKER
0x136b50808 2935 package body SYS.KUPW$WORKER
0x136b50808 9054 package body SYS.KUPW$WORKER
0x136b50808 1688 package body SYS.KUPW$WORKER
0x1358a19a0 2 anonymous block

Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:”XYYZONE”.”TAB_COMM_POINTS_HISTORY”:”YMAX”]
ORA-00920: invalid relational operator
ORA-06512: at “SYS.DBMS_METADATA”, line 1546
ORA-06512: at “SYS.DBMS_METADATA”, line 1583
ORA-06512: at “SYS.DBMS_METADATA”, line 1891
ORA-06512: at “SYS.DBMS_METADATA”, line 3956

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 8358

—– PL/SQL Call Stack —–
object line object
handle number name
0x136b50808 19208 package body SYS.KUPW$WORKER
0x136b50808 8385 package body SYS.KUPW$WORKER
0x136b50808 2935 package body SYS.KUPW$WORKER
0x136b50808 9054 package body SYS.KUPW$WORKER
0x136b50808 1688 package body SYS.KUPW$WORKER
0x1358a19a0 2 anonymous block

Job “SYSTEM”.”SYS_EXPORT_TABLE_01″ stopped due to fatal error at 04:46:52

[oracle@Oracle112 dmp]$ expdp system/password directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107 version=10.2.0.3

Export: Release 11.2.0.2.0 – Production on Wed Mar 16 04:52:55 2011

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


通过数据库链导出遇到ORA-39126错误
  • ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_
  • ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_ | ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_ ...

    通过数据库链导出遇到ORA-39126错误
  • expdp遇到ORA-39126错误
  • expdp遇到ORA-39126错误 | expdp遇到ORA-39126错误 ...

    通过数据库链导出遇到ORA-39126错误
  • ORA-39126 ORA-00904 ORA-06512解决过程
  • ORA-39126 ORA-00904 ORA-06512解决过程 | ORA-39126 ORA-00904 ORA-06512解决过程 ...