Re: Unloading more than 2Gb

graemel_at_enertel.nl wrote:
:>
:> One way you might be able to avoid having to write too much code is
 by
:> using a named pipe into which you send your SQL*Plus output and from
 out
:> of which you read the results into gzip or compress and then send
 that to
:> a file.

< ... stuff deleted ... >

:> Of course, this will only work for you if you have a good compression
:> ratio with your data and there's enough disk space.

< ... stuff deleted ... >

:> Hoping to have been of service,
:>
:> Graeme

Another solution if you have sufficient disk space and if the compressed file still exceeds 2Gb should be to use the split command applied on the named pipe.

The split command splits files into parts of any size.

HTH.
Sincerely,
Jerome. Received on Thu Sep 11 1997 - 00:00:00 CDT