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: NEXT usage in CREATE TABLESPACE statement

Re: NEXT usage in CREATE TABLESPACE statement

From: mis2o <ora_question_at_yahoo.co.uk>
Date: 10 Oct 2006 09:47:44 -0700
Message-ID: <1160498864.392027.158370@b28g2000cwb.googlegroups.com>

Brian Peasland napísal(a):
> > is there a way how to specify the size of the initial extent with
> > locally managed tablespaces using AUTOALLOCATE?
>
> Forgot to answer the question above.
>
> IIRC, and it's been a while since I tested it, if you have AUTOALLOCATE
> for your LMT, and you specify an INITIAL extent for your segment, Oracle
> will use that as a "guide" to determine how big the first extent should be.
>
>

thanks much :) Received on Tue Oct 10 2006 - 11:47:44 CDT

Original text of this message

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