Confusion about Minimum Extent Clause

[anuragmin]

Hi,
I am a little confised about the minimum extent storage clause and how is it different than the initial extent clause.

For example
ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 100M NEXT 1MB MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K;

This statement is giving me an error
ORA-02143: invalid STORAGE option

Please Suggest.

Thanks
Anurag

[amar]

You have two SQL statements.

Change the "MB" to "M" in "NEXT" and your 1st statement will work:

ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 100M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)


-amar

[sreddy]

Originally posted by anuragmin
Hi,
I am a little confised about the minimum extent storage clause and how is it different than the initial extent clause.

For example
ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 100M NEXT 1MB MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K;

This statement is giving me an error
ORA-02143: invalid STORAGE option

Please Suggest.

Thanks
Anurag

INITIAL & NEXT refers to the SIZE of extent ( say in so and so KB/MB)
MINEXTENTS & MAXEXTENTS count of the extents( or say 2, 10 or n)