" GB File Limit

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 Wed Mar 21 2001 - 03:46:42 CST