Storage clause problem in 9.2

From: <Tim_at_nospam.com>
Date: Sun, 22 Dec 2002 06:33:32 GMT
Message-ID: <ttma0vgeu1ammjgac03sd3s3e5jd6c9au6@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 - 00:33:32 CST