Re: max INITIAL extent allowable

The largest file on most operating systems used to be 2Gb. I suspect that it can be larger now on the later
versions of Windows, but I would seriously consider not going above 2Gb unless you have a massive database
and need to keep the data file counts down. Some 3rd party software (backup software etc) may assume that the limit is 2Gb and not allow you to backup (or worse - not restore) them.

And I'd say that the initial extent can only be as big as the largest empty datafile size (as they can't span datafiles).

Poke around on the www.microsoft.com site, there must be some specs for NTFS. Oracle note [NOTE:62427.1]

• basically you need to put patches on to support the 64-bit addressing scheme used in files > 2 Gb
• Recovery times
• Make sure AUTOEXTEND is off ! (if it extends to 4Gb and on 8.1.7 it will crash....) => it implies start with larger than 4Gb....
• more bugs come out of the woodwork when the files are larger than > 2Gb.
• Theoretical 16Tb on NTFS
• 4Gb on DOS FAT (-- no no no)

Alun

"dkrpata1" <dkrpata1_at_cox.net> wrote in message news:adPG8.25018$db7.1064305_at_news2.west.cox.net...
> Anyway to tell, specifically for Windows 2000 and Solaris 2.8 Operating
> systems what the max allowable size for a file would be. The manuals say
> that the max size for the initial extent clause in Oracle is goverened by
> the operating system, and I'm assuming that is associated with the max
size
> for a file? Just seeing if it is easily found somewhere?
>
> Thanks
>
>
Received on Wed May 22 2002 - 12:44:49 CDT