[askdba] EXP/IMP or Copy data through T1 line

  • From: VuCanDo <vuquyen@xxxxxxxxx>
  • To: ASKDBA <askdba@xxxxxxxxxxxxx>
  • Date: Mon, 19 Sep 2005 15:14:48 -0700

Hi everyone,

I need to move 1TB or more data (100 STATIC tables) from client back to our 
database here through delicate T1 line between the 2 databases using DB 
Link. Our client is running on Oracle 8.1.7.0 <http://8.1.7.0> on AIX and 
our box is on Oracle 10.1.0.3 <http://10.1.0.3> on Sun Solaris. This is how 
I plan to attack the problem. I have approximate 3 weeks to transfer over 
(24 hours)

1. Execute Exp/Imp for all small tables with compress using dblink in our 
box.
2. Using Copy or Insert (DB Link) command to move data by YEAR (One at the 
time) for some other BIG tables (100GB) since the columns in the table will 
be naming little different then original table.

Please advice me the CON & PRO or another solutions about this sceniaro.

Thanks in advance,

Vu

Other related posts: