RE: spool file size limit

There may be system limitations. If your OS (or critical apps) use 32 bits for file pointers, you'll have trouble with files >= 2 GB, even if Oracle will write them.

In 32-bit solaris 7, for example, we could create files > 2 GB but many of our utilities (perl, gzip, even ls -l) broke because they were not 'large-file aware'.

> -----Original Message-----
> From: Rachel Carmichael
> Sent: Wednesday, April 16, 2003 9:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: spool file size limit
>
>
> I've never hit a limit.... it would depend, I would think, on the
> amount of free space you have on your disk.
>
>
> --- "Bernard, Gilbert" wrote:
> > Hi,
> > someone can tell me what is the max file size can be spoolling out
> > from sqlplus.
> >
>

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sarnowski, Chris
  INET: csarnows_at_CuraGen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).