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

On 18 Jul 2006 03:23:58 -0700, etantonio_at_libero.it wrote:

Comments inline

>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 &
>

exp doesn't write to standard output, so you can't pipe anything. Instead use a named pipe, like this:

mkfifo exp_param.dat
compress exp_param.dat &
exp sc/sc_at_ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt

>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
>

The compress clause doesn't compress your data, but for each table determines the size and puts this value in the INIT clause of the CREATE TABLE statement that is written into the exportfile.

>Thanks for your help
>
>Antonio D'Ottavio
>www.etantonio.it/en
>
Received on Wed Jul 19 2006 - 03:02:10 CDT