Full Database Classic Export and Expdp Fails With ORA-39014 ORA-00600 qmxtrScalarIsRewritable (Doc ID 764065.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 06-Jun-2013***
Checked as Top Hit on 09-NOV-2011


Symptoms

Full Database EXPORT and EXPDP are failing with ORA-00600 [qmxtrScalarIsRewritable:dft] ,

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [qmxtrScalarIsRewritable:dft], [], [], [], [], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1397
ORA-06512: at line 2
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 12:33:10
ORA-39014: One or more workers have prematurely exited.


From the associated ORA-00600 Trace the CURRENT SQL is like,

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmxtrScalarIsRewritable:dft], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CLUSTER_T', '7')), KU$.OBJ_NUM
,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'CLUSTER' ,KU$.SCHEMA_OBJ.OWNER_NAME FROM
SYS.KU$_CLUSTER_VIEW KU$ WHERE NOT (BITAND (KU$.SCHEMA_OBJ.FLAGS,16)=16) AND
KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND  NOT EXISTS (SELECT 1 FROM  SYS.KU$NOEXP_TAB A WHERE
A.OBJ_TYPE='CLUSTER' AND A.NAME=KU$.SCHEMA_OBJ.NAME AND A.SCHEMA=KU$.SCHEMA_OBJ.OWNER_NAME) AND
NOT EXISTS (SELECT 1 FROM  SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND
A.NAME=KU$.SCHEMA_OBJ.OWNER_NAME)
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
0x79babb18      1050  package body SYS.DBMS_METADATA
0x79babb18      1258  package body SYS.DBMS_METADATA
0x79babb18      1585  package body SYS.DBMS_METADATA
0x79babb18      1892  package body SYS.DBMS_METADATA
0x79babb18      4224  package body SYS.DBMS_METADATA
0x79bb5168      2062  package body SYS.KUPW$WORKER
0x79bb5168      6944  package body SYS.KUPW$WORKER
0x79bb5168      1314  package body SYS.KUPW$WORKER
0x79b78bc0         2  anonymous block


XDB is VALID with no INVALID Objects.

There are 2 matching Bugs which are closed because of Not Reproduced in house.

<Bug 6511566> : ORA-600 [QMXTRSCALARISREWRITABLE:DFT] ON EXPORT/SELECT    SYS.KU$_XMLSCHEMA_VIEW
<Bug 6313998> : ORA-600 [QMXTRSCALARISREWRITABLE:DFT] DURING FULL DATABASE EXPORT


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