ORA-00600 [qmcxpmapGetPfxNspXXX] When Exporting Table with XMLType Column
(Doc ID 2460419.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.
Symptoms
Exporting a table with XMLType column using BINARY XML storage fails with error:
Export: Release 11.2.0.4.0 - Production on Tue Sep 4 10:14:35 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/********@luprech DIRECTORY=DUMPDIR TABLES=ORCLTEST.XMLTABCOL DUMPFILE=table_XMLTABCOL.dmp logfile=table_XMLTABCOL.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.273 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "ORCLTEST"."XMLTABCOL" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-00600: internal error code, arguments: [qmcxpmapGetPfxNspXXX], [], [], [], [], [], [], [], [], [], [], []
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/pkg/oracle/exp/ORCL/DUMPS/table_XMLTABCOL.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at Tue Sep 4 10:14:54 2018 elapsed 0 00:00:16
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/********@luprech DIRECTORY=DUMPDIR TABLES=ORCLTEST.XMLTABCOL DUMPFILE=table_XMLTABCOL.dmp logfile=table_XMLTABCOL.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.273 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "ORCLTEST"."XMLTABCOL" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-00600: internal error code, arguments: [qmcxpmapGetPfxNspXXX], [], [], [], [], [], [], [], [], [], [], []
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/pkg/oracle/exp/ORCL/DUMPS/table_XMLTABCOL.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at Tue Sep 4 10:14:54 2018 elapsed 0 00:00:16
The stack trace is
qmcxpmapGetPfxFromNspId qmcxdEvtGetPrefix qmcxdEvtGetName
qmcxeEncEvent_Helper qmcxeEncodeEvents qmcxeEncodeXobExt qmxtkEvalXML2SC
evaopn2 evaopn2 qerlxtProcessRow qerlxtRop qertbFetch rwsfcd qerlxtCBPopulate
kpxsPopulateStream kpxsPopulate
qmcxeEncEvent_Helper qmcxeEncodeEvents qmcxeEncodeXobExt qmxtkEvalXML2SC
evaopn2 evaopn2 qerlxtProcessRow qerlxtRop qertbFetch rwsfcd qerlxtCBPopulate
kpxsPopulateStream kpxsPopulate
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |