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], [], [], [], []
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment