exp via pipe and compress

From: <sbatter_at_my-dejanews.com>
Date: Thu, 16 Jul 1998 16:13:13 GMT
Message-ID: <6ol8qp$ser$1@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:13:13 CDT