Re: max INITIAL extent allowable

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