ORA-00600[# Of Sumkeys Invalid] When Refreshing A Materialized View (Doc ID 397534.1)

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
Using ASM

Symptoms

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 . . .

Changes

The database was upgraded to 10.2.0.2.

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