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: question about initial extent

Re: question about initial extent

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 05 Jan 2003 04:12:21 GMT
Message-ID: <FgOR9.239362$qF3.20132@sccrnsc04>


200K, the other spec is the default minimum. So if you had specified nothing it would be 500K. You should be using uniform extents and locally managed tablespaces.
Jim
"andi" <andihp_at_flashmail.com> wrote in message news:16ce60f4.0301041846.2f268343_at_posting.google.com...
> Hi All.
> If a tablespace is created using clause MINIMUM EXTENT 500K
> then a table is created on that tablespace with storage clause INITIAL
200K,
> which size will be taken to create the initial extent for the table?
> 200K or 500K?
>
> TIA,
> andi
Received on Sat Jan 04 2003 - 22:12:21 CST

Original text of this message

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