Re: " GB File Limit

Maybe they told you the wrong max filesize for NTFS. It should be about 4 TB.

Martin

Norman Dunbar wrote:
>
> Greetings,
>
> This is a very interesting thread, to me anyway, for the following
> reasons :
>
> When I was on the DBA course for O7, I was told that 4 Gb was the max
> file size for an NT system - otherwise it would fall over.
> On our HP servers, there is a operating system limit of "gb anyway
> (unless I create the file system with the largefiles option).
>
> We have just re-created an Oracle 7.3.4 customer database here on site
> to do some performance testing for the customer.
> This was a cold backup of their own database which is running on NT4
> with SP6 applied.
> They have a SINGLE datafile for a single tablespace.
> The file is 28 Gig in size.
> There is 1.25 Gb free in this file.
> The database block size is 8192.
> The file system is NTFS.
> The database works fine.
>
> What have they/we done wrong as this caused me stress when I copied it
> all off tape - remembering the 4Gb limit I was told about on the course.
>
> Puzzled of Bradford :o)
>
> Regards, Norman.
>
> ------------------------------------------------------------------------
> --------
> Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Lynx Financial Systems Ltd. Fax: 0113 201 7265
> URL: http://www.LynxFinancialSystems.com
> ------------------------------------------------------------------------
> --------
>
> -----Original Message-----
> From: Mark Wagoner [mailto:mwagoner_at_iac.net]
> Posted At: Friday, March 16, 2001 9:15 PM
> Posted To: server
> Conversation: 2 GB File Limit
> Subject: Re: 2 GB File Limit
>
> 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..."
Received on Fri Mar 23 2001 - 06:45:49 CST