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.
