Tuesday, September 15, 2009

Hit Oracle bugs: ORA-600[16606] when alter cluster index

Sympton:

SQL> alter index TEST_USER.TEST_TABLE_N1 STORAGE ( MAXEXTENTS 2147483645 );
alter index TEST_USER.TEST_TABLE_N1 STORAGE ( MAXEXTENTS 2147483645 )
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [16606], [2], [3], [2585510728], [],
[], [], []

Related bug:

1350740: ALTER INDEX STORAGE ( NEXT 3 M) FAILS WITH ORA-600 [16606]


Affected versions:

8.1.6/8.1.7 on all platforms. (Mine is Solaris 9)

How to reprocedure: (Taken from above bug info)

1. create a cluster
CREATE CLUSTER ADE_SITE_CL (
CPFN VARCHAR2 ( 11) ,
VERAR VARCHAR2 ( 1) ,
WAF_NR NUMBER ( 3,0 )
)
Pctfree 0
Pctused 64
Size 800
Tablespace TS_1
Storage ( INITIAL 180000 K
NEXT 180000 K
MINEXTENTS 3
MAXEXTENTS 20
);

2. alter cluster
Alter Cluster ADE_SITE_CL
STORAGE ( NEXT 40000 K) ;

3. create an index
Create Index ADESTE_P on Cluster ADE_SITE_CL
Pctfree 10
Tablespace TS_1
Storage ( INITIAL 10 M
NEXT 10 M
MINEXTENTS 3
MAXEXTENTS 20
);

4. alter index
alter index ADESTE_P
STORAGE ( NEXT 3 M) ;
fails with ORA-00600: internal error code, arguments: [16606], [2], [3],
[52655056], [], [], [], []