Re: exp via pipe and compress

I've usually just used the 'uncompress' (which I think is an alias to 'compress -u') to fill the pipe. Something like:

    compress < exp.pipe > mydump.dmp (on the way out)

    and

    uncompress mydump.dmp.Z > exp.pipe (on the way in)

This has always worked fine on 4G+ export files under AIX. There is an article on the Oracle Metals Web support site about 'cat' and 'zcat' causing problems on some platforms, so I don't use them. Maybe that's where the errors are? I've never had problems with compress/uncompress on export dumps (i.e. without pipes when under 2G) or datafiles. Still, could be a problem specific to your platform?..

MotoX.

sbatter_at_my-dejanews.com wrote in message <6ol8qp$ser$1_at_nnrp1.dejanews.com>...
>
>
>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?
>
>TIA
>
>steve
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 16 1998 - 11:53:05 CDT