My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.