ORA 600 after rebuilding indexes

From: waltervdv <marcus.kuehl_at_t-online.de>
Date: 1 Nov 2001 04:43:42 -0800
Message-ID: <b2677297.0111010443.6d03ea8_at_posting.google.com>


Hallo !

A few days ago I made an index-rebuild on every index in our schema. Afterwords I checked out that all Indexes where OK (select * from user_indexes where status <> 'VALID').
Then I analyzed the schema by:

begin
  dbms_utility.analyze_schema('DBH','COMPUTE'); end;

This happend:

The following error has occurred:

ORA-00600: internal error code, arguments: [kcbgtcr_4], [3074], [3793], [1049600], [1], [], [], []

ORA-06512: at "SYS.DBMS_DDL", line 161
ORA-06512: at "SYS.DBMS_UTILITY", line 331
ORA-06512: at line 2

This error was due to a corrupt Index. I had to drop the Index and to create it new.
Afterwords i was able to analyze the schema.

Now my question:

Does anybody know what caused this index to be corrupted? How can I avoid this error (I want to build a job, that rebuilds all indexes every weekend)?

Thanks for any ideas !
We are using Oracle 8.1.6 on SunOS....

Marcus Received on Thu Nov 01 2001 - 13:43:42 CET

Original text of this message