Re: Re: datafile size

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Wed, 03 Nov 2004 00:48:05 +0200
Message-Id: <200411022248.iA2Mm6s07842@mail-fe75.tele2.ee>

Hi all!
Btw, in 10g with bigfile tablespaces you can have datafile sizes up to 128TB.

This means files with 2^32-1 blocks per datafile - it can be done because in a bigfile tablespace, the ROWID bits for relative fno are now used for block# as well. This effectively means, that you can have only one datafile in a bigfile TS.

Tane.

> On 11/02/2004 05:02:25 PM, David Sharples wrote:
> > there really is no practical limit for datafile sizes. The
> argrument
> > of no more than 2Gb is crass at best.
>
> That is not quite true. So called "2GB limit" is indeed gone, but
> here =20
> is what the fine manual says (Oracle Reference 9.2, database limits)

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 02 2004 - 16:44:04 CST