Expdp Fails With ORA-600 [17147] ORA-600 [17278] or Similar Internal Errors When the Parameter SCHEMAS is Used
(Doc ID 960091.1)
Last updated on DECEMBER 06, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
DataPump export started with user SYSTEM and parameter SCHEMAS fails with errors
ORA-00600: internal error code, arguments: [17114], [0x9FFFFFFFFCDF1F38], [], [], [], [], [], []
The trace file mentions:
ORA-00600: internal error code, arguments: [17114], [0x9FFFFFFFFCDF1F38], [], [], [], [], [], []
or ORA-600 [17147]
Current SQL statement for this session:
SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(:"SYS_B_00", :"SYS_B_01")),
KU$.OBJ_NUM ,
KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SCHEMA_OBJ.NAME
,KU$.SCHEMA_OBJ.NAME ,:"SYS_B_02" ,
KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_PROCDEPOBJ_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND NOT
BITAND(KU$.BASE_OBJ.FLAGS,:"SYS_B_03")!=:"SYS_B_04" AND KU$.BASE_OBJ.OWNER_NAME IN (
SELECT object_name FROM "SYSTEM"."SYS_EXPORT_SCHEMA_18" WHERE process_order = -:"SYS_B_05" AND
duplicate BETWEEN :"SYS_B_06" AND :"SYS_B_07") AND NOT EXISTS (...
or ORA-600 [17147]
Current SQL statement for this session:
SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(:"SYS_B_00", :"SYS_B_01")),
KU$.OBJ_NUM ,
KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SCHEMA_OBJ.NAME
,KU$.SCHEMA_OBJ.NAME ,:"SYS_B_02" ,
KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_PROCDEPOBJ_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND NOT
BITAND(KU$.BASE_OBJ.FLAGS,:"SYS_B_03")!=:"SYS_B_04" AND KU$.BASE_OBJ.OWNER_NAME IN (
SELECT object_name FROM "SYSTEM"."SYS_EXPORT_SCHEMA_18" WHERE process_order = -:"SYS_B_05" AND
duplicate BETWEEN :"SYS_B_06" AND :"SYS_B_07") AND NOT EXISTS (...
with a stack trace similar to:
kgherror kghfrmrg kghfre kghfrh_internal kghfrh $cold_qescaFree $cold_qerjoFetch qerjoFetch rwsfcd qerhjFetch qerflFetchOutside kpofrws opifch2 opifch opipls ...
Also an ORA-600 [17278] is a possible symptom of this issue.
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 |