Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export WITH compress

Re: export WITH compress

From: Hanspeter 'Happl' Oberlin <happl_at_mail.com>
Date: Tue, 30 Oct 2001 08:27:51 +0100
Message-ID: <happl-DC5645.08275130102001@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 - 01:27:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US