Re: export WITH compress

You can skip the pipe completely as exp will write to stdout on UNIX ...

exp parfile=<parfile> file=stdout 2>exp.log | gzip -1 >exp.dmp.gz

I've never been able to get imp to read stdin however. That would be nice.

-Kevin

"Hanspeter 'Happl' Oberlin" <happl_at_mail.com> wrote in message news:happl-DC5645.08275130102001_at_news.fu-berlin.de...
> In article <l3estt8vmu6l3rjssgjdqeov5dj7a82hsi_at_4ax.com>,
> Andreas Wizemann <AWizemann_at_fvvag.de> wrote:
>
> >How can i compress (or zip or gzip, whatever gives better results)
> >while export is still running, so file1 is compressed before or while
> >export writes to file2 ?
> >Maybe this could be done by a 'pipe' ? But i've never used a pipe
> >in unix!
>
> Yes. Not by a process pipe ( ... | ... ) but by a pipe file.
>
> Here's an expample:
>
> /etc/mnknod exp.dmp p
> cat exp.dmp | compress >exp.dmp.Z
> exp userid=... file=exp.dmp buffer=... .....
>
> With that solution you don't have to use multiple
> output files.
>
> Hope this helps!
>
> Greetings from Switzerland -- Gruesse aus der Schweiz
> Happl
Received on Tue Oct 30 2001 - 11:11:35 CST