Re: 2 Gig File limit under Solaris 2.51?

One other point worth mentioning is that even on 'large' jfs's (or raw partitions, for that matter) is that you may run into problems with the Oracle toolset - imp, exp, sqlldr will not handle files larger than 2G, even if your filesystem, LVM and Oracle datafiles can handle that.

Look at your Oracle install guide for platform specific information, and check with Oracle Tech. Sup. for the latest version status. Also look at using 'compressed pipes' to overcome some of the imp/exp problems.

MotoX.

David Shi wrote in message <6qtamj$lin$0_at_208.222.91.191>...
>On Wed, 12 Aug 1998 12:15:52 -0400, "Lisa Lewis" <lewis_at_med.pitt.edu>
wrote:
>
>>Can anyone tell me if a 2 gig file size limit exists under Solaris 2.51.
>
>Yes, there is. Solaris 2.6 can have file larger than 2G.
>
>>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
>
>2G is the maxsize you can get with the limit. I usually use something less
than
>2G since the backup software can't backup the 2G files.
>
>>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
>>
>
Received on Thu Aug 13 1998 - 05:14:35 CDT