ORA-00600[# Of Sumkeys Invalid] When Refreshing A Materialized View
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.
This error occurred in the following environment
Oracle 10.2.0.2 64-bit
HP-UX Itanium server 64-bit
Two node RAC database
The error occurred during the execution of an application procedure.
Procedure calls dbms_mview which does a refresh of a Materialized View
The error from the utility is:
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00081: address range [0x60000000000A7FA0, 0x60000000000A7FA4) is not readable
ORA-00600: internal error code, arguments: [# of sumkeys invalid], , , ,, , , 
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at "< package_name>", line 161
ORA-06512: at line 1
The error consistently reproduces when running the utility..
Call stack is similar to:
ksedst ksedmp ksfdmp kgerinv kgeasnmierr
kkqsGetSum kkqsGSumInHeap kkqslsum kkqspsum kkqsedrv kkqseqb kkqsrqb . . .
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