Re: How to pipe output from export into gzip?

In article <4cep2i$apg_at_gatekeeper.cng.com> james_w_klein_at_cngp.cng.com (James W. Klein) writes:

> Path: witch!nic.wat.hookup.net!hookup!lll-winken.llnl.gov!uwm.edu!vixen.cso.uiuc.edu!howland.reston.ans.net!swrinde!newsfeed.internetmci.com!in2.uu.net!news.cng.com!usenet
> From: james_w_klein_at_cngp.cng.com (James W. Klein)
> Newsgroups: comp.databases.oracle
> Date: Wed, 03 Jan 1996 20:27:04 GMT
> Organization: CNG Producing Company
> Lines: 11
> NNTP-Posting-Host: kleinjwb.cngp.cng.com
> X-Newsreader: Forte Free Agent 1.0.82
>
> Can someone give me a UNIX command line that will grab output from an
> Oracle full database export using exp, and pipe it into a compression
> utility like gzip?
>
> Thanks,
>
> James W. Klein (jklein_at_cngp.cng.com)
> CNG Producing Company
> New Orleans, LA
> U.S.A.
>

The following lines can be used to export to a file that will compress as it is being exported. The $expfile is a variable of the name of the export file.

# export to a compressed file
/etc/mknod $expfile p

cat < $expfile | /usr/local/bin/gzip > $expfile.gz & exp system/manager file=$expfile full=y || { echo "Exp Failed"; date ; exit 1; }

Hope this helps.

Mary Hunt Received on Thu Jan 04 1996 - 00:00:00 CET