SuperCluster: EXPDP failing with error ORA-39126, ORA-1427 when exporting types
(Doc ID 1988428.1)
Last updated on OCTOBER 17, 2023
Applies to:
Solaris Operating System - Version 11.1 and laterOracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Oracle SuperCluster T5-8 Hardware - Version All Versions and later
Oracle SuperCluster M6-32 Hardware - Version All Versions and later
Oracle Database Cloud Schema Service - Version N/A 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
----- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |