ORA 600 after rebuilding indexes
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