Re: Huge export. On-the-fly compression

If you are using unix, you can do the following (syntax assumes HP-UX):

# create named pipe

mkfifo expdat.dmp

# compress the output from the named pipe

cat expdat.dmp | compress > expdata.dmp.Z &

exp .....

# Wait for background process to complete compression of export file

wait

You can also use the same technique with either gzip or the zip/unzip shareware utilities, of course with different syntax for those commands. FYI - zip will provide much better compression than compress. I use it where I work for this purpose (as well as others).

Hope this helps,

Allen

"Svein Fossdal" <sveinf_at_petrodata.no> wrote in message news:vgtf6.65459$oG1.2228791_at_pouncer.easynews.com...
> I'm exporting a database that's too large for
> my free disk space. Does anybody know if there is a way to
> compress the export file WHILE the data is being written to it?
>
> Thanks,
>
> Svein Fossdal
>
>
>
Received on Sat Feb 24 2001 - 21:50:07 CET