ORA-00600:[qmcxeWSNQ1] when using Data Pump Export to Export a Table with XMLTYPE Column (Doc ID 2029217.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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