On Thu, 26 Feb 2004, elmer mendoza wrote:
..
> I need to know what command or steps should i do in order to swiftly
> transfer this large chunk of data. and i really need to do this fast and
> orderly.. Since this is really critical, can i also getthe fastest reply
> i can have..
I think your simplest option is exp/imp combination through a pipe. That
way there will be no more temporary dump files. However this is slow
because the IMP will require rebuilding indexes.
here you go..
export EXPPIPE=/home/orly/scripts/exp.pipe
rm -f $EXPPIPE
mknod $EXPPIPE p
$ORACLE_HOME/bin/exp \
scott/[EMAIL PROTECTED] file=$EXPPIPE \
DIRECT=Y owner=scott \
compress=Y grants=Y indexes=Y rows=Y buffer=1048576 &
this means EXP will write to the pipe (and will block, since the pipe will
block I/O until the pipe is read from). so you run another process
$ORACLE_HOME/bin/imp scott/[EMAIL PROTECTED] \
BUFFER=1048576 FILE=$EXPPIPE GRANTS=Y INDEXES=Y ROWS=Y \
FULL=Y ANALYZE=N TOUSER=radius FEEDBACK=1000
there are some magical incantations of IMP which allows to bypass the
creation of rollback segments (this speeds things up considerably), you'll
just have to RTFM on that.
HOWEVER: this won't be very fast (maybe >1 day for 50GB! unless your
target system has really really fast hardware). the fastest is to dump
then use direct path load, that would avoid going through the
transactioning system altogether. but.. that would be harder.
BTW IMP and index rebuilds eats temporary tablespace like there's no
tomorrow. so that the load runs fast, consider having huge amounts of RAM
(16GB or so?) and have a temporary tablespace on a RAM drive.
---
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
--
Philippine Linux Users' Group (PLUG) Mailing List
[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
