This error normally occur because of the INDEX or table structure is in consistent mode.
Analyze the index structure and tables.
If index structure is failed in analyze , drop the index and recreate the index.
please ensure it is shadow instance or Default instance.
Step:0
SQL> select INDEX_NAME from dba_indexes where table_name=’DD03L~’;
INDEX_NAME
——————————————————————————–
DD03L^0
DD03L^7
DD03L^6
DD03L^2
DD03L^3
DD03L^4
DD03L^5
DD03L^1
SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.
ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[], [], [], [], []
Step:1
SQL> set pagesize 0
SQL> set long 90000
SQL> SELECT DBMS_METADATA.GET_DDL(‘INDEX’,’DD03L^1′,’SAPSR3′) from dual;
CREATE INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;
Step:2
SQL> DROP INDEX “SAPSR3”.”DD03L^1″;
Index dropped
Step:3
SQL> CREATE INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;
Index created.
Step:4
SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.