Re: export dump larger than 2Gbytes

One of the Oracle/Unix Gurus has sent me a script a while ago, which I modified a bit and posting it right now. It's using named pipes (man mknod) and split (man split) and obviously gzip. Good luck.

#!/bin/csh -vx

setenv ORACLE_BASE=/export/apps/oracle
setenv ORACLE_HOME=/export/apps/oracle/734
setenv ORACLE_SID=DBLP2

setenv UID sys/password
setenv FN $ORACLE_BASE/export/`uname -n`_export.`date +%m_%d_%y`.dmp setenv PIPE /tmp/exp_tmp.dmp
setenv MAXSIZE 2000m
setenv EXPORT_WHAT 'full=y direct=y feedback=100000' setenv EXPORT_LOG=$ORACLE_BASE/export/`uname -n`_export.`date +%m_%d_%y`.log

mknod $PIPE p

date > EXPORT_LOG
( gzip < $PIPE ) | split -b $MAXSIZE - $FN. & exp userid=$UID file=$PIPE $EXPORT_WHAT >>& EXPORT_LOG date >> EXPORT_LOG
rm $PIPE

On Sat, 28 Aug 1999 12:09:13 +0800, eddisonng_at_hotmail.com wrote:

>Hi,
>
>May anyone help me on the question :
>
>Exporst oracle objects and having the dump file larger than 2Gbytes.
>However, the O/S only support max. 2Gbytes file size. We are using Sun
>w/s and has no tape drive. We think about using compress command, but
>in the case the compress dump also > 2G, what can we do ?
>
>Thanks anyone!
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email