How to exp & imp at the same time on different machines

By using pipe and dd, exp and imp can run at the same time on different machines.
Step1. target DB server azsource:
cd /oracle/azsource/data02/wenjin_tmp
mknod azsource.dmp p
imp AZ/AZ file=azsource.dmp tables=mytable ignore=y log=azsource.log fromuser=AZ touser=AZ commit=y buffer=51200000 indexes=N constraints=N; &
Step2. source DB server aztarget:
cd /oracle/aztarget/data09/wenjin_tmp
mknod azsource.dmp p
exp AZ/AZ tables=mytable:PART01 file=azsource.dmp buffer=102400000 direct=y log=azsource.log indexes=N grants=n triggers=N statistics=none &
dd bs=1048576 if=azsource.dmp | rsh azsource.oracle.com ‘dd bs=1048576 of=/oracle/azsource/data02/wenjin_tmp/azsource.dmp’    &
Advertisements

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: