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)
Operating system dependent. Limited by maximum operating system file =20
size; typically 222 or 4M b.
***************************************************************************=
**********
The formulation "4M b ", coined with the crystal clarity typical of =20
Oracle Corp. documentation, means "4 million file system blocks ". =20
Typical FS block size is 4k, so 4,000,000*4096=3D16GB. In particular, =20
this limit does apply on all Linux boxes. I 've seen files grow above =20
16GB and become corrupt. So, limits are much bigger now, but you still =20
cannot go above warp 9.
