datafile size 2004-11-02 - By Tanel Poder
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
|
|
