Expdp Fails With ORA-600 [17147] ORA-600 [17278] or Similar Internal Errors When the Parameter SCHEMAS is Used
Last updated on FEBRUARY 01, 2017
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4Information in this document applies to any platform.
Symptoms
DataPump export started with user SYSTEM and parameter SCHEMAS fails with errorsORA-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
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms