My Oracle Support Banner

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

Last updated on APRIL 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 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.


Following error reported when using Data pump export:
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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.