Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!news.maxwell.syr.edu!newsfeed.vmunix.org!newsfeed.hanau.net!bnewspeer00.bru.ops.eu.uu.net!bnewspeer01.bru.ops.eu.uu.net!bnewsifeed03.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <3cff2d51$1_1@news.vo.lu> Subject: Re: maximum size of an extent Date: Thu, 6 Jun 2002 10:45:19 +0100 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 Lines: 36 Message-ID: <3cff2f2f$0$231$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1023356719 reading.news.pipex.net 231 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:149719 X-Received-Date: Thu, 06 Jun 2002 04:20:31 MST (news.easynews.com) No. However you could control this in one of two ways. 1. Limit the size of your datafiles. (YUK) 2. Use Locally managed tablespaces with uniform extent sizes. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "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. > > > > >