Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!newsfeed.r-kom.de!news0.de.colt.net!news1.de.colt.net!not-for-mail From: "Knut Talman" Newsgroups: comp.databases.oracle.misc Subject: Re: maximum size of an extent Date: Thu, 6 Jun 2002 14:41:06 +0200 Organization: Colt Telecom GmbH Lines: 14 Message-ID: References: <3cff2644_2@news.vo.lu> NNTP-Posting-Host: h-213.61.134.194.host.de.colt.net X-Trace: crusher.de.colt.net 1023367395 16704 213.61.134.194 (6 Jun 2002 12:43:15 GMT) X-Complaints-To: usenet@news1.de.colt.net NNTP-Posting-Date: 6 Jun 2002 12:43:15 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Xref: easynews comp.databases.oracle.misc:82576 X-Received-Date: Thu, 06 Jun 2002 05:51:13 MST (news.easynews.com) > 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? AFAIK, you can't. The maximum extent size depends on the size of the datafile. So if you want a maximum extent size of 10k you have to create datafiles w/ a size of 10k. Regards, Knut