Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create tablespace in 9i

Re: Create tablespace in 9i

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 25 Dec 2002 00:30:29 +1000
Message-ID: <p4ZN9.9411$jM5.26655@newsfeeds.bigpond.com>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:_XSN9.9199$jM5.26230_at_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
> >

Hi Timmy,

... and thankfully as you're using a LMT (trust Howard, you are), that awful pctincrease of 10% will get what it deserves, the cold shoulder.

How could you !!

Cheers

Richard Received on Tue Dec 24 2002 - 08:30:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US