Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!b28g2000cwb.googlegroups.com!not-for-mail
From: "mis2o" <ora_question@yahoo.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: NEXT usage in CREATE TABLESPACE statement
Date: 10 Oct 2006 09:47:44 -0700
Organization: http://groups.google.com
Lines: 17
Message-ID: <1160498864.392027.158370@b28g2000cwb.googlegroups.com>
References: <1160492278.697939.49480@b28g2000cwb.googlegroups.com>
   <1160492548.035187.291590@m7g2000cwm.googlegroups.com>
   <1160494989.542456.53900@i42g2000cwa.googlegroups.com>
   <J6xGwr.HJM@igsrsparc2.er.usgs.gov>
NNTP-Posting-Host: 89.173.28.186
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1160498869 31439 127.0.0.1 (10 Oct 2006 16:47:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 16:47:49 +0000 (UTC)
In-Reply-To: <J6xGwr.HJM@igsrsparc2.er.usgs.gov>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060830 Firefox/1.5.0.7 (Debian-1.5.dfsg+1.5.0.7-1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: b28g2000cwb.googlegroups.com; posting-host=89.173.28.186;
   posting-account=N7eJ7w0AAADRs5XSEH3qGmlMpDKO5iCp
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276950


Brian Peasland nap=EDsal(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 b=
e=2E
>=20
>=20


thanks much :)