欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

ORA-39126 ORA-00904 ORA-06512解决过程

程序员文章站 2023-12-25 21:55:27
...

expdp test/123456 dumpfile=b.dmp directory=DUMP_DLSP 使用数据汞的过程中遭遇如下错误,从我使用的参数来看,并没有使用什么高

expdp test/123456 dumpfile=b.dmp directory=DUMP_DLSP
使用数据汞的过程中遭遇如下错误,从我使用的参数来看,并没有使用什么高级的参数,都是最最普通的参数。查看MOS,,没发现有跟我比较类似的报错信息。通过10046也没跟踪到有价值的报错信息。

Export: Release 11.2.0.3.0 - Production on Mon Feb 17 14:17:44 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "TEST"."SYS_EXPORT_SCHEMA_08": test/******** dumpfile=b.dmp directory=DUMP_DLSP REUSE_DUMPFILES=y
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-00904: : invalid identifier

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8996

----- PL/SQL Call Stack -----
object line object
handle number name
0x613b0898 20462 package body SYS.KUPW$WORKER
0x613b0898 9028 package body SYS.KUPW$WORKER
0x613b0898 10935 package body SYS.KUPW$WORKER
0x613b0898 13698 package body SYS.KUPW$WORKER
0x613b0898 2654 package body SYS.KUPW$WORKER
0x613b0898 9697 package body SYS.KUPW$WORKER
0x613b0898 1775 package body SYS.KUPW$WORKER
0x6145f9f0 2 anonymous block

Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-00904: : invalid identifier

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8996

----- PL/SQL Call Stack -----
object line object
handle number name
0x613b0898 20462 package body SYS.KUPW$WORKER
0x613b0898 9028 package body SYS.KUPW$WORKER
0x613b0898 10935 package body SYS.KUPW$WORKER
0x613b0898 13698 package body SYS.KUPW$WORKER
0x613b0898 2654 package body SYS.KUPW$WORKER
0x613b0898 9697 package body SYS.KUPW$WORKER
0x613b0898 1775 package body SYS.KUPW$WORKER
0x6145f9f0 2 anonymous block

Job "TEST"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error at 14:17:48

询问同事是否这个数据库一直存在数据汞不能使用的问题,答复一直可以使用,是刚发现的问题。
回想这几天我对这个数据库的操作,怀疑到可能是权限的问题,因为之前做过一个操作,取消了DBMS_METADATA的public权限。
而数据汞导出数据过程中是要获取表结构信息的。
因此尝试重新赋予DBMS_METADATA为public权限,问题解决。

--------------------------------------------------------------------------------

Linux-6-64下安装Oracle 12C笔记

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

--------------------------------------------------------------------------------

上一篇:

下一篇: