Re: 2 Gig File limit under Solaris 2.51?

On Thu, 13 Aug 1998 19:56:08 +1000, David <David_at_home.aus> wrote:
>
>
>2.51 is limited to 2G files
>2.6 is unlimited
>BUT Oracle 8.0, 8.0.1...,8.0.3,8.0.4.1 and 8.0.4.2 will not work with files > 2G
>
>... tablespace files and export files are still restricted to 2G limit even when
>running 2.6.
>
>& Oracle is not the only problem, most 3 party tools [today] will not support
>large files
>ie. sorts, compilers ...
>
>According to Oracle, 8.0.4.3 will support large files. Would need to see this in
>writing first [the bastards].

The "Release Note" with 8.0.5 says it provides native support for large files, caveat the file system and volume manager.

>Expected GA 18/9, but don't bet on this date
>
>Not 100% positive about 8.0.4.2
>
>GL.
>
>
>Lisa Lewis wrote:
>
>> Can anyone tell me if a 2 gig file size limit exists under Solaris 2.51.
>> The system administrator tells me yes but the Oracle 8.0 Install manual ( p
>> 1-10) leads me to believe that Solaris 2.51 has no such limit. Also if the
>> 2G limit exists, then should I specify 'autoextend maxsize 2G' instead of
>> unlimited. I would then have to more closely monitor how much space is left
>> in those datafiles and then add another datafile? And of course I would
>> won't to do this before the allocated datafiles fill up and not as a result
>> of an error message. Any information/suggestions will be greatly
>> appreciated.
>>
>> Lisa
>
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Aug 13 1998 - 17:42:29 CDT