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: joel garry <joel-garry_at_home.com>
Date: 10 Oct 2006 17:21:07 -0700
Message-ID: <1160526067.235015.8360@m7g2000cwm.googlegroups.com>

mis2o wrote:
> 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 :)

More detail at
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:25322140091802

jg

-- 
@home.com is bogus.
http://www.bendshire.com/
Received on Tue Oct 10 2006 - 19:21:07 CDT

Original text of this message

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