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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 15 Feb 2004 15:08:10 -0800
Message-ID: <1076886443.457551@yasure>

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sun Feb 15 2004 - 17:08:10 CST