Re: 2 GB File Limit

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 19 Mar 2001 17:02:17 -0000
Message-ID: <985021353.12251.0.nnrp-08.c30bdde2@news.demon.co.uk>

The limit is based on one of two things.

Firstly, if you are storing on a FAT drive, then yes, there is a maximum file limit of 2gb I believe.

Secondly, it depends on your db_block_size as to the maximum size of your datafile - as documented in the, umm, oracle documentation.

""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111242_at_jshemail.herold.com...
> Hi,
> I read somewhere that there is a 2 GB file limit in case of NT.
>
> What will happen if i have my datafiles and tablespaces set to autoextend
on
> and the file size reaches 2GB. Will this crash/freeze the database and
what
> should be done in case this happens.
>
> Please suggest.
>
> Thanks
> Anurag
>
>
> --
> Posted from mr1.ash.ops.us.uu.net [198.5.241.86]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Mar 19 2001 - 11:02:17 CST