Re: Create tablespace in 9i

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 24 Dec 2002 17:25:19 +1100
Message-ID: <_XSN9.9199$jM5.26230@newsfeeds.bigpond.com>

AAAAAAAAAAAAAAAGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHH!

Look up locally managed tablespaces in the Oracle documentation.

And then learn to search google.com for posts on similar subjects.

Your search words could usefully include the phrase "LMT".

Regards
HJR "Timmy Sin" <tswsin_at_yahoo.com> wrote in message news:au8tj6$422$1_at_news.hk.linkage.net...
> Hi All,
>
> I found something strange when creating tablespace on a 9i database. The
> tablespace is created as follows:
>
> Create tablespace ABC datafile '/dbfile/abc.dbf' size 5M default storage
> (initial 512K next 512K minextents 1 Maxextents 999 pctincrease 10);
>
> However, when I query the dictionary, the initial extent is only 64K, not
> the expected 512K. Do someone have any idea on my situation?
>
> Thanks.
>
> Regards,
> Timmy
>
>
Received on Tue Dec 24 2002 - 00:25:19 CST