"Fred Puhan" <f_puhan_at_precise.com> wrote in message
news:f_puhan-E1B714.16031206062002_at_vienna7.his.com...
> In article <3cff2d51$1_1_at_news.vo.lu>, "GR" <guy.rodesch_at_cie.etat.lu>
> wrote:
>
> > 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?
>
> Extent growth is controlled by the values specified in the CREATE
> statement in a cascading hierarchy: first at the table/object level,
> then at the tablespace level, and finally using Oracle defaults.
It depends. If the tablespace has local extent management then the above
does not apply. 8.1.7 can and should use local extent management.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Jun 06 2002 - 16:53:05 CDT
