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 11.2.0.4 and laterOracle 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
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 |
Cause |
Solution |
References |