Re: exp/imp to/from multiple compressed files ?

From: Prem <premjhere_at_gmail.com>
Date: Sat, 15 Jul 2006 02:46:16 +0530
Message-ID: <56d3d5610607141416k39703508qaf80ecc595d4fa52@mail.gmail.com>

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

Received on Fri Jul 14 2006 - 16:16:16 CDT