topic Re: compressing an export with oracle in Operating System - HP-UX

compressing an export with oracle

Brian Gebhard — Mon, 25 Mar 2002 19:57:28 GMT

The following is my current script:

cat $HOME/admin/P01/exp/exp_daily.dmp | gzip > /u20/test.Z

exp / file=$HOME/admin/P01/exp/exp_daily.dmp owner='owner' buffer=5000000 direct=y
***
Now $HOME/admin/P01/exp/exp_daily.dmp is a pipe created the following way:
mknod exp_daily.dmp p

I exp to the pipe file, then the compress grabs the info in the pipe and sends it to the *.Z file. I import basically the same way. I zcat into a pipe, then import from the pipe into oracle. My problem is I'm trying to use a different compression tool, gzip to be exact. I substitute gzip for compress and change the .Z extension to .gz. It appears to work fine. When I try to import using gunzip it doesn't send the info to the pipe. It creates a new file with the same name as the *.gz file but minus the .gz chars. So basically it just uncompresses the file. The following is the script I run:

impst / buffer=5000000 file=/u20/exp_daily.dmp fromuser='owenr' touser='owner'

gunzip /u20/test.dmp.Z > /u20/exp_daily.dmp
**
I've tried changing > to | with no success. I was on the phone with hp and they didn't have an answer for me either. Is there any other compress tool that works with pipes? I need to compress on the export.

Re: compressing an export with oracle

harry d brown jr — Mon, 25 Mar 2002 20:05:35 GMT

Brian,

try this:

gunzip /u20/test.dmp.Z -c > /u20/exp_daily.dmp

live free or die
harry

Re: compressing an export with oracle

harry d brown jr — Mon, 25 Mar 2002 20:05:40 GMT

Brian,

try this:

gunzip /u20/test.dmp.Z -c > /u20/exp_daily.dmp

live free or die
harry

Re: compressing an export with oracle

Brian Gebhard — Mon, 25 Mar 2002 20:06:10 GMT

Sorry my current script is actually

cat $HOME/admin/P01/exp/exp_daily.dmp | compress > /u20/test.Z &

exp / file=$HOME/admin/P01/exp/exp_daily.dmp owner='owner' buffer=5000000 direct=y

Re: compressing an export with oracle

harry d brown jr — Mon, 25 Mar 2002 20:11:53 GMT

Brian,

dd if=$HOME/admin/P01/exp/exp_daily.dmp | gzip -c > /u20/test.Z &

live free or die
harry

Re: compressing an export with oracle

harry d brown jr — Mon, 25 Mar 2002 20:13:00 GMT

Brian,

Make that:

dd if=$HOME/admin/P01/exp/exp_daily.dmp | gzip -9 -c > /u20/test.gz &

"-9" will compress the crap out of the file - and on ascii files it really squashes it!

live free or die
harry

Re: compressing an export with oracle

Brian Gebhard — Mon, 25 Mar 2002 20:32:05 GMT

Yes I do realize -9 compresses it very much but doesn't it also drastically increase the amount of time the export/compression will take? Won't the compression take longer?

Re: compressing an export with oracle

harry d brown jr — Mon, 25 Mar 2002 21:14:55 GMT

Brian,

Yes the compression will take longer, and in your case if you are immediately importing the data, then a -9 doesn't make sense, unless you need to keep the export.zipped file small.

live free or die
harry