Thanks, yeah, I know that for instance Veritas File System will allow you to
have files greater than 2GB. But you're right, I asked the person why they
wanted to put the entire table into one extent and it's just hardheadedness
(if that's a word). But it made me interested to see how Oracle checked the
OS for that value. For example I tried to create an inital extent of
2902000K or even 2902M and it failed. But no worries, I'm not going to
worry about myself anymore.
"A.Liggins" <A.Liggins_at_hotmail.com> wrote in message
news:acgleh$ntp$1_at_helle.btinternet.com...
> 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 - 13:13:11 CDT
