Darren -

Add a split command to the background process. Something like...

gzip $GzipFlags < $Named_pipe | split $SplitFlags ${ExpPath}/${Export} &

You used compress, but gzip is similar. This will split your gzip'd output
into bite size chunks as defined by $SplitFlags

...Tony Nelipovich

-----Original Message-----
From: Darren S. Eyers [mailto:[Email Address Removed] Monday, September 30, 2002 11:02 AM
To: LazyDBA.com Discussion
Subject: Oracle 7.3.4 Big Exports on Solaris 5.6????


Hi Gurus!

Have been unable to export a large database on Solaris 5.6 with the
export stream being compressed as it writes to the export file. Below
is a copy of the script I used from http://www.dbaoncall.net/:

#!/bin/ksh
rm -r /tmp/exp_fifo_file
mkfifo /tmp/exp_fifo_file
compress > $2 < /tmp/exp_fifo_file &
sleep 2
exp file=/tmp/exp_fifo_file parfile=$1

Any ideas what to do on Oracle 7.3.4 when this creates a file over the
2gb limit and dies?
The only way round this is to export schemas, then tables is that does
not work with out all the over bits like triggers and extract them
separately, but what can you do if one table takes up over 2gb of space
compressed?

I guess use create table as into sub tables. Is there a better way on
this platform using Oracle 713. If only Oracle 8i!

Thanks
Darren


------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

==============================================================================
Oracle LazyDBA home page