Scenerio
ORACLE RDBMS Version: 10.2.0.3.0 - x86_64 GNU/Linux
Throws error message : ORA-00600: internal error code, arguments: [13013], [5001], [517], [4260059], [139], [4260059], [3], [] in the alert log and sometimes, the database stops working ...
Workaround
SQL> Select object_name,object_type,owner from dba_objects where data_object_id=517;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
COL_USAGE$
TABLE SYS
SQL> analyze table SYS.COL_USAGE$ validate structure online;
Table analyzed.
SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;
analyze table SYS.COL_USAGE$ validate structure cascade online
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],[]
SQL> select index_name from dba_indexes where table_name='COL_USAGE$';
INDEX_NAME
------------------------------
I_COL_USAGE$
SQL> Set long 1000000
SQL> Select dbms_metadata.get_ddl('INDEX','I_COL_USAGE$','SYS') from dual;
DBMS_METADATA.GET_DDL('INDEX',
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM"
SQL> drop index "SYS"."I_COL_USAGE$";
Index dropped.
SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM";
Index created.
SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;
Table analyzed. ---------------------------------------------------------------------------------------------------------------
Oracle Doc ID : 816784.1
No comments:
Post a Comment