Re: Compressed Oracle export directly to tape

From: Christian Mondrup <reccmo_at_sc03.sctp.dk>
Date: 10 Jun 1998 09:23:12 GMT
Message-ID: <6llja0$9e6$1@news.net.uni-c.dk>

GValdes_at_apa.org wrote:
: I am trying to do a compressed Oracle export directly to tape, using a Unix
: named pipe.

: gtar -zcvf /dev/rmt/0h /tmp/exp.dmp &

: exp instance/passwd parfile=export.par

: using file=/tmp/exp.dmp (rw named pipe)

: But, I get the following error messages:

: EXP-00028: failed to open /tmp/exp.dmp for write
: EXP-00222:
: System error message 4

: I can get the system to compress to disk using a pipe
: (zcat instead of gtar).

: Is there a way to do this without writing to disk ?

rm -f exp.dmp
mknod exp.dmp p
dd if=exp.dmp | gzip --best -c | dd of=/dev/rmt0h &

exp userid=system/<pwd> file=exp.dmp

: Thanks

: Gonzalo

: -----== Posted via Deja News, The Leader in Internet Discussion ==-----
: http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
Christian Mondrup, Computer Programmer
Scandiatransplant, Skejby Hospital, University Hospital of Aarhus Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark Phone: +45 89 49 53 01, Telefax: +45 89 49 60 07 Received on Wed Jun 10 1998 - 04:23:12 CDT