Thursday, September 10, 2015

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

Sometimes during a query (select) it appears this fatal error

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

I usually solve it recreating the index or indexes of the affected table

To know and generate the sentences to rebuild the index/indexes from the affected table use this sentence


select 'alter index ' ||owner|| '.' ||index_name|| ' rebuild;' from dba_indexes where table_name='affected table name';

For example, to rebuild all indexes from a table named test01 and owner Gorka, the steps will be....

1.- SQL> select 'alter index ' ||owner|| '.' ||index_name|| ' rebuild;' from dba_indexes where table_name='TEST01';

'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILD;'
--------------------------------------------------------------------------------
alter index gorka.test_index01 rebuild;
alter index gorka.test_index_PK rebuild;
alter index gorka.test_index02 rebuild;
alter index gorka.test_index03 rebuild;


4 rows selected.

2.- execute the sentences generated (copy the list and paste in sqlplus and then return)

SQL>
Index altered.
SQL>
Index altered.
SQL>
Index altered.
SQL>
Index altered.



No comments:

Post a Comment