Try something like this:
------------ cut -----------------------
# -- export_dl.sh:
ORACLE_HOME=/opt/oracle/product/8.1.6
ORACLE_SID=cmsrpt1
OUT_FILE=/u09/mytools/expimp/expdat.dmp.gz
export ORACLE_HOME ORACLE_SID OUT_FILE
#
# Create a pipe for output of export
#
PEXP=/tmp/exp$$
mknod $PEXP p
chmod 777 $PEXP
#
# Start export
#
cat $PEXP|gzip -c |split -b 2000m ${OUT_FILE} &
/opt/oracle/product/8.1.6/bin/exp FILE=$PEXP \
PARFILE=/u05/mytools/expimp/exportparam_dl
#
# End export
#
rm -f $PEXP
exit
------------ cut -----------------------
# -- exportparam_dl :
LOG=/u05/mytools/logs/export_dl.log
OWNER=dloader
CONSISTENT=Y
COMPRESS=N
------------ cut -----------------------
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Bookmarks