Re: Compressed export to Tape

Dirk,
Here is a script I have for Export through a UNIX pipe where the export file is compressed.

#!/bin/csh
#Program name: exp_pipe.csh
#
#Purpose: Export from Oracle database thru a UNIX pipe where
# the export file is compressed. Finally write the
# export file directly to tape. The UNIX pipe will
# use a certain amount of disk space which will grow
# and shrink as the export is taken and compressed, however
# you will not need to dedicate
# enough filesystem space for the whole export file.
#
# This script requires a parfile named "pipeexp_par"
#
# RUN THIS SCRIPT IN THE BACKGROUND!
# SYNTAX: exp_pipe.csh &
#

setenv ORACLE_HOME <oracle home path>
setenv ORACLE_SID <sid>

/etc/mknod pipe.dmp p

compress <pipe.dmp>/dev/rmt/0m &
$ORACLE_HOME/bin/exp parfile=$ORACLE_HOME/bin/pipeexp_par

sleep 5
\rm -f pip.dmp Received on Wed Aug 09 1995 - 00:00:00 CEST