EXPORT WITH COMPRESS SCRIPT

                   EXPORT WITH COMPRESS SCRIPT

               

# BEFORE RUNNING THIS SCRIPT, USE the mknod command to create a named pipe

# called /dev/PIPE.dmp (mknod is Unix command, PIPE.dmp is an arbitrary name).

# Then set environment variables for ORACLE_HOME, ORACLE_SID, and DUMPDIR, as

# well as PATH if needed.

# If you save the script as, say, exp_comp.sh, type

#             % exp_comp.sh & 

# at the Unix prompt to run it.

# WARNING: You must have unique names for each pipe if you have

# multiple concurrent executions of this script.

trap '' 1 # nohup

# Set these to appropriate values

ORACLE_HOME=

ORACLE_SID=

DUMPDIR=

# Customize PATH if needed

PATH=/bin:/usr/bin:${ORACLE_HOME}/bin:/usr/local/bin:/usr/lbin

export ORACLE_HOME ORACLE_SID PATH

LOGFILE=$DUMPDIR/exp${ORACLE_SID}.log

exec >$LOGFILE 2>&1

echo "Exporting $ORACLE_SID database. start `date`"

# Customize this as needed

exp system/manager GRANTS=Y FULL=Y INDEXES=Y COMPRESS=Y FILE=/dev/PIPE.dmp &

compress </dev/PIPE.dmp > $DUMPDIR/exp$ORACLE_SID.dmp.Z &