SuperCluster: EXPDP failing with error ORA-39126, ORA-1427 when exporting types

Asset ID:	1-72-1988428.1
Update Date:	2015-10-09
Keywords:

Solution Type Problem Resolution Sure

Solution 1988428.1 : SuperCluster: EXPDP failing with error ORA-39126, ORA-1427 when exporting types

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Solaris SPARC Operating System - Version 11.1 and later
Oracle SuperCluster T5-8 Hardware - Version All Versions and later
Oracle SuperCluster M6-32 Hardware - Version All Versions and later
Information in this document applies to any platform.

Symptoms

Full database export (expdp) of editioned enabled schemas failing with below error :

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [SYNONYM:"UFMSAPWRX"."XTR_STOCK_PKG"]
ORA-01427: single-row subquery returns more than one row
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

Errorstack shows the below failing query :-

ORA-01427: single-row subquery returns more than one row

----- Current SQL Statement for this session (sql_id=31g8jqbft47na) -----

SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TYPE_T',
'7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TYPE'
,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_TYPE_VIEW
KU$,TABLE(DBMS_METADATA.FETCH_SORTED_OBJNUMS(100001)) KU1$ WHERE
KU$.OBJ_NUM =KU1$.NUM1 ORDER BY KU1$.NUM2
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object      line object
handle    number name
7bab58818      3665 package body SYS.DBMS_METADATA
7bab58818      4269 package body SYS.DBMS_METADATA
7bab58818      4581 package body SYS.DBMS_METADATA
7bab58818      8160 package body SYS.DBMS_METADATA
7b6953c90     11566 package body SYS.KUPW$WORKER
7b6953c90      2808 package body SYS.KUPW$WORKER
7b6953c90     10422 package body SYS.KUPW$WORKER
7b6953c90      1824 package body SYS.KUPW$WORKER
7b69593b0         2 anonymous block

Cause

Issue is identified as Unpublished Bug 20476776 - ORA-39126, ORA-1427 ON EXPDP.

Solution

This bug is fixed in future version 12.2 of the RDBMS.

Check if there is a interim <Patch 20476776> available for your database version and platform. If not, please open a Service Request.

References

<BUG:20624429> - MERGE REQUEST ON TOP OF 11.2.0.4.0 FOR BUGS 20459432 15922287 20476776
<BUG:17379684> - ORA-1427 ON EXPORT DATA PUMP JOB OF SCHEMA WITH FORCED EDITIONING
<BUG:15922287> - DBMS_METADATA FOR A VIEW FAILED WITH ERROR ORA-1427
<NOTE:1118596.1> - DataPump Export (EXPDP) Fails With ORA-1427 When Using A XMLTYPE Column With Object Grants
<NOTE:1584076.1> - Edition-Based Redefinition: Invalidated ADT Tables will remain Invalid after an Edition is dropped
<BUG:20476776> - ORA-39126, ORA-1427 ON EXPDP
<BUG:20558313> - ORA-39126, ORA-1427 ON EXPDP
<BUG:20628738> - PSE FOR BASE BUG 20624429 ON TOP OF 11.2.0.4.0 FOR GENERIC PLATFORM

Attachments

This solution has no attachment