ORACLE_SID=TEST1;export ORACLE_SID
export ORACLE_HOME=/oracle9i/product/9.2.0
set `date`
filename=/oracle9i/expTEST1full.$3$2$6
export filename
PIPEDIR=/oracle9i/pipedir;export PIPEDIR
/etc/mknod $PIPEDIR/pipeabc p
echo "nohup compress $filename.comp &" > write_pipeabc
sh write_pipeabc
sleep 5
date >> /oracle9i/pipedir/TEST1full.$3$2$6.out
echo ' Full Export of TEST1 is going on........... Please wait'
$ORACLE_HOME/bin/exp \'/ as sysdba \' buffer=1073741824 feedback=100000 file=$PIPEDIR/pipeabc \
statistics=none grants=Y direct=y \
indexes=Y rows=Y full=Y compress=Y 2>> /oracle9i/TEST1full.$3$2$6.out
No comments:
Post a Comment