# export and compress using pipe
export EXPDATE=`date "+%m%d_%H%M"`
export DUMPFILE=demo_user_${EXPDATE}.dmp
export EXPLOGFILE=demo_user_${EXPDATE}.log
/usr/sbin/mknod ${DUMPFILE} p
/usr/bin/gzip < ${DUMPFILE} > ${DUMPFILE}.gz &
sleep 30
exp scott/tiger file=${DUMPFILE} log=${EXPLOGFILE} \
owner=SYSADM consistent=y buffer=10000000 direct=Y statistics=none
tail -5 demo_user_${EXPDATE}.log | mailx -s "demo export" me@google.com
# import from compresed file using pipe
export DUMPFILE=myexp.dmp
export IMPLOGFILE=imp_user_${EXPDATE}.log
/usr/sbin/mknod ${DUMPFILE} p
imp scott/tiger file=${DUMPFILE} log=${IMPLOGFILE} \
fromuser=SYSADM touser=SYSADM indexes=y ignore=y buffer=10000000 commit=y &
/usr/bin/gzip -d < ${DUMPFILE}.gz > ${DUMPFILE}
sleep 300
tail -5 demo_imp_user_${EXPDATE}.log | mailx -s "demo export" me@google.com
