Re: Unloading more than 2Gb

Bruce Bristol wrote:
>
> Hello,
>
> I have a table that consists of about 20Gb of data on a Sun Solaris
> system.
>
> I know I can use SQL*Plus to create a flat ASCII file, but Solaris has a
> file size limitation of 2Gb (we won't be upgrading to Solaris 2.6 until
> next year which will allow 1Tb size files.
>
> Anyway, is there a way I can still use SQL*Plus to have to write to a
> different file once it hits the 2Gb file size or do I need to write a
> program to do this?
>
> Thank you!
>
> -Bruce

Have you tried spooling to a named pipe? mknod mypipe -p
nohup compress -c > lots_of_data.Z - < mypipe &

sqlplus
...

   spool mypipe
   select ....
exit Received on Tue Sep 09 1997 - 00:00:00 CDT