Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export dump larger than 2Gbytes
Also you might want to take out gzip if your server is very CPU
hungry, since it can take up a considerable amount of CPU usage
On Mon, 30 Aug 1999 16:48:59 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
>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
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Mon Aug 30 1999 - 11:58:24 CDT