Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export dump larger than 2Gbytes

Re: export dump larger than 2Gbytes

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 30 Aug 1999 16:58:24 GMT
Message-ID: <37cab7fe.12026948@news.earthlink.net>


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 email

Received on Mon Aug 30 1999 - 11:58:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US