Oracle Database Discussions

Hi all,

Oracle : 10.2.0.3
OS - SunOS

I need to alter staorage parameter for a particular table with following defination:


CREATE TABLE "IBROKER"."ABC"
( "ID" NUMBER(20,0)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 104857600 NEXT 1310720 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "IBROKER_DAT"

I want to alter storage parameter to unlimited, issuing following command m getting the error:

SQL> Alter table IBROKER.abc storage (maxextents unlimited);
Alter table IBROKER.abc storage (maxextents unlimited)
*
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted


My question is how can we alter storage parameter for table when its maxextents reach to its highest value.


Thanks.