Parameters looks ok, Just use gzip instead of compress . File extention should be .gz instead of .Z If you can try larger recordsize than 65K ,try it.
Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 09 Apr 2002 06:28:20 -0800 I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).