OraFAQ Forum: Server Utilities » EXP/IMP or Copy data over T1 lines

Home » RDBMS Server » Server Utilities » EXP/IMP or Copy data over T1 lines

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP/IMP or Copy data over T1 lines [message #137772]

Fri, 16 September 2005 13:15

vqd2697
Messages: 36
Registered: October 2004

Member

Hi everyone,

I need to move 1TB or more data (100 tables) from client back to our database here through delicate T1 lines between the 2 databases using DB Link. Our client is running on Oracle 8.1.7.0 on AIX and our box is on Oracle 10.1.0.3 on Sun Solaris. This is how I plan to attack the problem.

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 give me the CON & PRO or another solutions about this sceniaro.

Thanks in advance,

Vu

Report message to a moderator

Previous Topic:	Imp 00069 and Imp 00021
Next Topic:	Import termination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 06:10:47 CST 2024