EXPDP OF TRANSPORTABLE TABLESPACE FAILS WITH ORA-39126 AND ORA-01422 EVEN WITH PATCH14215851 APPLIED

(Doc ID 1537612.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following symptoms have been attributed to this article :-

 

a) Transportable tablespace EXPDP is being performed

b) During EXPDP errors of following type are hit :-

Processing object type TRANSPORTABLE_EXPORT/GRANT/CROSS_SCHEMA/OBJECT_GRANT
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [OBJECT_GRANT:"XXXX"]
ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

OR

Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [OBJECT_GRANT:"XXXX"]

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 9001

 

It seems the problem each time is on an 'OBJECT_GRANT' phase and the line numbers seem specific to line95 and line9001

but this article might be useful provided (A) is true.

 

c) Patch14215851 has been applied but the problems still remain

 

 




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms