SuperCluster: EXPDP failing with error ORA-39126, ORA-1427 when exporting types (Doc ID 1988428.1)

Last updated on OCTOBER 09, 2015

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

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