EXPORT

[alexandre]

I'm trying to export an 8.0.6 database on the HP-UX 10.20 platform. The size of the export size is about to grow more than the max file size on the OS, and then fail. What i have to do? I would consider exporting tablespace by tablespace. What is the exact commands to do that?

Regards
Alexandre

[hrishy]

Hello

You Can break up the export file into smaller files use export to a PIPE and have compress and split read the pipe. The result is a couple of 500meg compressed files that consistute the export. At 500meg, any utility can deal with this files and I can move them around easier.

#!/bin/csh -vx

setenv UID /
setenv FN exp.`date +%j_%Y`.dmp
setenv PIPE /tmp/exp_tmp_ora8i.dmp

setenv MAXSIZE 500m
setenv EXPORT_WHAT "full=y COMPRESS=n"

echo $FN

cd /nfs/atc-netapp1/expbkup_ora8i
ls -l

rm expbkup.log export.test exp.*.dmp* $PIPE
mknod $PIPE p

date > expbkup.log
( gzip < $PIPE ) | split -b $MAXSIZE - $FN. &
#split -b $MAXSIZE $PIPE $FN. &

exp userid=$UID buffer=20000000 file=$PIPE $EXPORT_WHAT >>&
expbkup.log
date >> expbkup.log


date > export.test
cat `echo $FN.* | sort` | gunzip > $PIPE &
#cat `echo $FN.* | sort` > $PIPE &
imp userid=sys/o8isgr8 file=$PIPE show=y full=y >>& export.test
date >> export.test

tail expbkup.log
tail export.test

ls -l
rm -f $PIPE

The code is shamelessly copied from tomkytes book.

regards
Hrishy

[vinit]

Originally posted by hrishy
Hello

The code is shamelessly copied from tomkytes book.

regards
Hrishy

thanx anyway. Could b useful for others who don't have the book.

[aarroyob]

Hi,

Export to disk:

mknod /tmp/exp_pipe p
compress < /tmp/exp_pipe > export.dmp.Z &
exp file=/tmp/exp_pipe ....

Export directly to tape:

mknod /tmp/exp_pipe p
dd if=/tmp/exp_pipe of= &
exp file=/tmp/exp_pipe ....

Hope that helps

Angel