Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator2-la!propagator-la!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server Subject: Re: maximum size of an extent Date: Fri, 7 Jun 2002 05:54:01 +1000 Organization: ihug ( New Zealand ) Lines: 28 Message-ID: References: <3cff2d51$1_1@news.vo.lu> NNTP-Posting-Host: p53-tnt5.syd.ihug.com.au X-Trace: lust.ihug.co.nz 1023393259 29135 203.173.136.53 (6 Jun 2002 19:54:19 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Thu, 6 Jun 2002 19:54:19 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:149785 X-Received-Date: Thu, 06 Jun 2002 12:51:45 MST (news.easynews.com) No. However, in 8.1.7, you can create locally managed tablespaces that then proceed only ever to allocate the extent sizes they've been created to allocate ("uniform size" is the magic clause). With them in place, it matters not a jot what the table *says* it wants as its initial or next extent size, it gets what the tablespace says it will get. Regards HJR "GR" wrote in message news:3cff2d51$1_1@news.vo.lu... > Hello, > We use Oracle 8.1.7.2 as the database of our SAP R/3 46C system. Could we > limit the maximum size of an extent in the init.ora configuration file? > > > Thanks in advance, > Guy. > > > > >