| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: What shall I do to export to a file bigger than 2 GB
A copy of this was sent to "Pedro Tavares" <pedrotavares_at_cmvm.pt>
(if that email address didn't require changing)
On Wed, 24 Mar 1999 11:29:22 -0000, you wrote:
>in HP-UX 10.20
>
>Thanks in advance
>
>Pedro Tavares
>Lisbon, Portugal
>
You could export to a tape device or if you want to goto disk, you can use a pipe to export to 'compress' or 'split'. (or compress and then split). For speed, I export to split creating a series of 500m files. Here is an example:
setenv UID sys/xxxxx
setenv FN exp.`date +%j_%Y`.dmp.gz
setenv PIPE /tmp/exp_tmp.dmp
echo $FN
cd /u01/atc-netapp1/expbkup
ls -l
#remove last export
rm expbkup.log export.test exp.*.dmp.* $PIPE
mknod $PIPE p
date > expbkup.log
split -b 500m $PIPE $FN. &
exp userid=$UID buffer=20000000 file=$PIPE full=y >>& expbkup.log
date >> expbkup.log
date > export.test
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 -------------------------------------------------------
this script exports the full database into a series of 500m files. It then 'reconstructs' the original file after the export is done using cat into the pipe and tests the integrity of the export using IMP show=y....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |