Datapump Schema Export terminates with ORA-39014, ORA-39029 ORA-31672 (Doc ID 1333511.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 22-May-2013***

Symptoms

Processing object type SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
- ORA-00600: [17147]
- ORA-00600: [kghfrh:ds]
CALL STACK
==========

-- ORA-00600 [17147]
[03]: kgherror [KGH]<-- Signaling
[04]: kghfrmrg [KGH]
[05]: kghfre [KGH]
[06]: kghfrh_internal [KGH]
[07]: kghfrh [KGH]
[08]: ksudlc [ksu]
[09]: kssdel [VOS]
[10]: ksupop [ksu]
...

-- ORA-600 [kghfrh:ds]
[03]: kghnerror [KGH]<-- Signaling
[04]: kghfrh_internal [KGH]
[05]: kghfrh [KGH]
[06]: ksuabt [ksu]
[07]: ksupop [ksu]
[08]: opiodr []
[09]: rpidrus []
...

 

----- Session Cursor Dump -----
Current cursor: 37, pgadep=3
...

Cursor#37(0x2b63a5122da8) state=BOUND curiob=0x2b63a7962140
curflg=4e fl2=420 par=(nil) ses=0x8b0367328
----- Dump Cursor sql_id=0w64bzsu400m0 xsc=0x2b63a7962140 cur=0x2b63a5122da8 -----
Dump Parent Cursor sql_id=0w64bzsu400m0 phd=0x8ade61980 plk=0x5b68b8100
sqltxt(0x8ade61980)=SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('PROCACTINS_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,'PROCACT_INSTANCE' FROM SYS.KU$_PROCACT_INSTANCE_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0 AND KU$.BASE_OBJ.OWNER_NAME IN (SELECT object_name FROM "SYSTEM"."SYS_EXPORT_SCHEMA_03" WHERE process_order = -55 AND duplicate BETWEEN 1 AND 1) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE=KU$.BASE_OBJ.TYPE_NAME AND A.NAME=KU$.BASE_OBJ.NAME AND A.SCHEMA=KU$.BASE_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.BASE_OBJ.OWNER_NAME) AND KU$.PREPOST=1

Changes

The issue occurs when the table to be exported uses expression filters.

col EXPR_COLUMN form a20
col ATTRIBUTE_SET form a20

select EXPR_COLUMN, ATTRIBUTE_SET
from ALL_EXPFIL_EXPRESSION_SETS
where owner='TC'
and EXPR_TABLE='ELSA_REG_RULESET';


EXPR_COLUMN          ATTRIBUTE_SET
-------------------- --------------------
AKTE_RULE            AKTEATTRIBSET
ANTRAG_RULE          ANTRGATTRIBSET
AZU_RULE             AZUATTRIBSET
FACHPROZ_RULE        FACHPROZATTRIBSET
FRIST_RULE           FRISTATTRIBSET
GPRA_RULE            GPRAATTRIBSET
IPC_RULE             IPCATTRIBSET
PBL_EXT_RULE         PBLEXTATTRIBSET
PBL_RULE             PBLATTRIBSET
VORGANG_RULE         VORGATTRIBSET
VST_RULE             VSTATTRIBSET

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