Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: maximum size of an extent

Re: maximum size of an extent

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 6 Jun 2002 14:41:06 +0200
Message-ID: <adnld3$ga0$1@crusher.de.colt.net>


> 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<SID>.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 Received on Thu Jun 06 2002 - 07:41:06 CDT

Original text of this message

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