Re: What is the best way to copy 2G table data between two databases

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 16 Feb 2004 21:48:52 +0100
Message-ID: <c0ra98$i0b$1@news1.tilbu1.nb.home.nl>

Daniel Morgan wrote:

> Mladen Gogala wrote:
>

>> On Sun, 15 Feb 2004 10:03:50 -0800, Daniel Morgan wrote:
>>
>>
>>> And exactly how does an insert statement get data from one database
>>> into another? Send 2GB to a spool file?
>>
>>
>>
>> insert /*+ append */ into table1(col1,col2,col3,..,colN)
>> select col1,col2,col3,..,colN from table2_at_remotedb;
>>
>> This is elementary, my dear Morgan. If I'm not mistaken, you are one of
>> the experts that were scolding me for my objections to some oracle
>> shenanigans not so long ago.

>
>
> I would agree except that it requires going across a db link. What
> will take forever ... can be done with TTS in minutes.
>

Guess you will have to set your students to work, then. From the top of my head:
Compaq DL380/2*Pentium 4/2GB memory/O8iRel3EE - receiving end Compaq DL530 (? 5-something)/4 Pentium III/4GB/O8iR2SE - sending end.

From flat table into partitioned table: 7.5 Million records in 13 minutes, using CTAS with where clause. Original table approx. 120M records.

-- 

Regards,
Frank van Bortel

Received on Mon Feb 16 2004 - 14:48:52 CST