Thanks TK.
"Thomas Kyte" <tkyte_at_oracle.com> wrote in message
news:achmpu0g1h_at_drn.newsguy.com...
> In article <XcRG8.25179$db7.1080802_at_news2.west.cox.net>, "dkrpata1"
says...
> >
> >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.
> >
>
> max extent size is 2gig regardless of OS.
>
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.
817/a76961/ch43.htm#11789
> (look for database extents)
>
> it is a myth that things are better in a single extent.
>
>
> >
> >"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
> >> >
> >> >
> >>
> >>
> >
> >
>
> --
> Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Thu May 23 2002 - 02:24:34 CDT
