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


Oracle LazyDBA home page