Re: Re: datafile size
- From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
- To: <gogala@xxxxxxxxxxxxx>, <davidsharples@xxxxxxxxx>
- Date: Wed, 03 Nov 2004 00:48:05 +0200
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
