error on maxextents in table...

[raf]

hi,
I created this tablespace:
CREATE TABLESPACE TBS DATAFILE 'C:\....\XXX01.dbf' SIZE 500M REUSE DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0) ONLINE;

When I try to insert a new record in table ST I get this error:

ORA-01631:maxextents(256) reached in table TOM.ST

I tried to increase maxextents: (user=system)
ALTER TABLE TOM.ST STORAGE(MAXEXTENTS 500);

but I get this error:
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted

How can I resolve this error?
Thanks
Raf

[engiri]

Alter table permission for you
in that user ?

[engiri]

Sorry .. mine is wrong

[gbrabham]

Determine the size of the table based on the rows you will have
then REBUILD the table with the CORRECT storage parameters .. initial size and next extent size....

HTH
Gregg

[kausik_m123]

U can have maxextents increased to Unlimited also but apply that if u require to.