Re: maximum size of an extent

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 7 Jun 2002 05:54:01 +1000
Message-ID: <adoel8$sef$1@lust.ihug.co.nz>

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" <guy.rodesch_at_cie.etat.lu> wrote in message news:3cff2d51$1_1_at_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<SID>.ora configuration
file?
>
>
> Thanks in advance,
> Guy.
>
>
>
>
>
Received on Thu Jun 06 2002 - 14:54:01 CDT