ORA-39126 ORA-00904 ORA-06512 Solution Process
Expdp test/123456 dumpfile = B. dmp directory = DUMP_DLSP
The following error occurs when using data mercury. According to the parameters I used, no advanced parameters are used, which are the most common parameters. Check the MOS. No error message similar to me is found. No valuable error information was found through 10046.
Export: Release 11.2.0.3.0-Production on Mon Feb 17 14:17:44 2014
Copyright (c) 1982,201 1, 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 []
The 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 []
The 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
Ask a colleague if this database has been unable to use data such as mercury. The answer is always usable, which was just discovered.
Looking back to my operations on this database over the past few days, I suspect that it may be a permission issue because I have previously performed an operation to cancel the public permission of DBMS_METADATA.
In the process of exporting data from data Mercury, the table structure information must be obtained.
Therefore, try to re-grant DBMS_METADATA the public permission to solve the problem.
--------------------------------------------------------------------------------
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
--------------------------------------------------------------------------------