Re: Storage clause problem in 9.2

You're doing nothing wrong. You've encountered the fact that 9i uses locally managed tablespaces by default (and a bloody good thing that is too).

You almost certainly have a LMT which allocates nothing but 1M extents. Therefore, your request for a 50M extent is honoured by giving you 50 1MB extents.

You should be happy: this way, nothing but 1MB extents for ANY segment can exist, therefore there is zero risk of fragmentation, and everything is sweet.

Oh, and we don't give a monkey's any more about the number of extents a segment acquires, so 50 extents is perfectly reasonable.

Regards
HJR <Tim> wrote in message news:ttma0vgeu1ammjgac03sd3s3e5jd6c9au6_at_4ax.com...
> I used the following storage clause in Oracle 8.1.7/win2k and it
> worked fine by creating 1 extent of 50mb but in Oracle 9.2.0.1.0/win2k
> it creates 50 extents of 1mb each. What am I doing wrong? Thx.
>
> CREATE TABLE dailyData(
> .
> .
> .
> )
> STORAGE ( INITIAL 50M
> NEXT 10M
> MINEXTENTS 1
> MAXEXTENTS UNLIMITED
> PCTINCREASE 0)
> TABLESPACE user_data1;
Received on Sun Dec 22 2002 - 02:09:35 CST