Re: Problem to arrange a compress on the fly to an export

etantonio_at_libero.it wrote:
> Good Morning,
> I need to arrange an export and at the same time compress the result,
> I want to do this in a shell script, at the moment I use this
>
> exp sc/sc_at_ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
> |compress &
>
> and I also have no result with the following form
>
> exp sc/sc_at_ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
> LOG=ciaolog.txt
>
> Thanks for your help
>
> Antonio D'Ottavio
> www.etantonio.it/en
>

Try exporting to a pipe and then have compress read from the pipe...similar to the following:

mknod exp.pipe p
exp u/p_at_tns parfile=my_parfile file=exp.pipe log=exp.log & compress < exp.pipe > my_dump.compressed &

Alternatively, this works great with gzip. The last line would be:

gzip < exp.pipe > my_dump.gz &

To import, uncompress into the pipe and have imp read from the pipe.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown