Re: exp via pipe and compress

sbatter_at_my-dejanews.com wrote:
> I talked to oracle to get around > 2GB exp filesize limitation
> They suggest:
> cat < /dev/exp.pipe > compress.Z &
> exp userid/passwd file=/dev/exp.pipe .... &
>
> this works fine on small exports. if i do a full the compress.Z file
> is corrupt. if i do zcat compress.Z | more i can see bad sql statements
> and garbase where my create and grant statements should be. Oracle support
> is being typical. The exp logfile reports export without warnings. So it looks
> like compress isnt reading from the pipe correctly.
>
> Exp to tape works but is at current 2 tapes and slow as sh*t.
>
> OS Solaris 2.6 ( recent recommended patches )
> Oracle 7.3.3.5.0
> hardware Sun Ultra 2 single 300Mhz
>
> Has anybody run into something similar? Am i doing something wrong?
> Are they any alternatives?

Simply use gzip and a named pipe (man mkfifo): (syntax for bash)

$ mkfifo fifo
$ (gzip < fifo) > archive.gz &

Now you can start your export utility (the named pipe will ´wait´ for your input) and take ´fifo´ as filename.

import the file:

$ (gunzip < archive.gz) > fifo &

start import with ´fifo´ as import file.

I personally used it on Solaris 2.5, Oracle 7.2.2 and got a compression about 95% (7GB -> 350 MB) :-)
If you have problems, send me an e-mail.

Sigrid Received on Thu Jul 16 1998 - 17:09:58 CDT