[QUOTE][i]Originally posted by badrinathn [/i]
[B]Hi,
How do I calculate the Intial extent,next extent values for
1) createing tablespaces
2) createing tables;

Can you please suggest

Badrinath [/B][/QUOTE]
suppose u have
intial 1m
next 2m
minextents 3
maxextents 121
pctincrease 20

Now, U have minextents=3 so u whenever u create table atleast 3 extents is reqd
Now for size,
FIrst extent will be 1m (inital 1m)
Next extent Will be 2m (Next 2m)
from third extent PCTINCREASE also used
SO for NExt (3'rd) extent will be
last extent*(1+pctincrease/100)
here it is 2*(1+20/100)=2(1.2)=2.4M
And it will take multiple of os block.

So ur extent will be 1m,2m,2.4m
Values of storage parameter at table level will look first
then at TS level Then at Default

kuckoo