Re: datafile with no maxsize set

From: Matthias Wirtz <Matthias.Wirtz_at_epost.de>
Date: Sun, 2 May 2004 22:08:10 -0400
Message-ID: <c75fch$ibkpj$1@ID-151394.news.uni-berlin.de>

"sarab" <sarabjeetd_at_hotmail.com> wrote in news:<I8Dkc.754$ar5.151_at_news.cpqcorp.net>...

> When a tablespace is created with a datafile(with autoextend ON) and no

> maxsize is specified, how does oracle determine the maxtend value for the

> file in sys.filext$?.

> The database is 10g.

On my system (9.2.0.1 in Linux) I have a maxextend value of 4194302 bytes (4GB).

I don't think that this is the max file size the 2.4 kernel could handle but I would expect that the maxextend value represents the max file size the OS can handle.

Are you using some kind of virtual hard drive that is actually only memory?

--

Matthias Wirtz - Norfolk, USA

Received on Sun May 02 2004 - 21:08:10 CDT