Dennis, though there is more than a TB of disk space, the need is ever growing and hence this space crunch now. Soon space will be added.
Though writing to 2 locations is a solution, i was looking for a script that would put all in one place ... compressed. Comes in handy many times.
One of our friends on this list shared this with me. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ for sun solaris: DUMPDIR="/app/links/tabledumps/usage" today=`date +%Y%m%d` DUMPFILE="/app/links/tabledumps/usage/usagetabledump.$today.dmp.Z" PIPEFILE="/app/links/tabledumps/usage/exp_pipe.pipe" MAXSIZE="1024m" logstarttimes="$LOGSDIR/usagetimes_tabledump"
print Starting usage export backup at `date` startime=`date +%Y%m%d%H%M%S`
/etc/mknod $PIPEFILE p
( compress < $PIPEFILE ) | split -b $MAXSIZE - $DUMPFILE. & /u01/app/oracle/product/8.1.7/bin/exp file=$PIPEFILE parfile=$datafile
to import /etc/mknod imp_pipe p cat `echo filenames.* | sort` | uncompress > imp_pipe & then do your import ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Let me try it. Thanks Dennis & Raj.
Regards | Jp. -- http://www.freelists.org/webpage/oracle-l