ORA-00600:[qmcxeWSNQ1] when using Data Pump Export to Export a Table with XMLTYPE Column

(Doc ID 2029217.1)

Last updated on MAY 23, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Following error reported when using Data pump export:
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "GLPSPRD"."GLPS_TRN_INVOICE" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-00600: internal error code, arguments: [qmcxeEncEndDoc1], [], [], [], [], [], [], [], [], [], [], []

+Error stack:

qmcxeEncEndDocument qmcxeEncEvent_Helper qmcxeEncodeEvents qmcxeEncodeXobExt qmxtkEvalXML2SC evaopn2 evaopn2 qerlxtProcessRow qerlxtRop qertbFetch rwsfcd qerlxtCBPopulate kpxsPopulateStream kpxsPopulate qxxqPopulate spefcpfa spefmccallstd pextproc pgmcetc_execute_trusted_c pciccc_call_c kkxmcexe

 +Export of CTAS of problematic table also fails with same error.

 +Following query does not reproduce the error:

select a.xml_column.getClobVal() from  mytable a;

+Issue reproduces when running following query:

select SYS_XMLT_2_SC(xml_column) from mytable

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