Re: Description of sys.filext$

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 11 Aug 1999 09:39:50 GMT
Message-ID: <37b14381.10468252@news.siol.net>

On Tue, 10 Aug 1999 15:37:55 -0400, Doug Cowles <dcowles_at_bigfoot.com> wrote:

>I know this has autoextend files, but what are
>maxextend and inc columns?

The syntax for extendable datafiles is:

ALTER DATABASE DATAFILE '<filename>' AUTOEXTEND ON

   NEXT x MAXSIZE y;

In filext$ the x and y are represented (expressed in db blocks) in:

inc = NEXT               (x/db_block_size)
maxextend = MAXSIZE      (y/db_block_size)

>- Dc.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Aug 11 1999 - 04:39:50 CDT