Re: 2 GB File Limit

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Fri, 16 Mar 2001 16:14:53 -0500
Message-ID: <98tvod$v60$1@genma.iac.net>

The size limit is a function of the block size. The larger the block size, the larger the allowable data file size.

Regardless of the limit, however, once you hit it any inserts or updates that result in a new extent will fail. I can't recall the exact error message but it is something like, "failed to extend data file..."

""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 Fri Mar 16 2001 - 15:14:53 CST