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

Eric Parker wrote:

> Daniel
>
> A couple of years ago we daily copied 4 GBytes of data in 250 tables
> through database links using CREATE TABLE AS SELECT. I don't believe
> any individual table was 2 GBytes (I cannot be definite on this).
> The copy took place within a Sun E10K Gigabyte links. We were running
> 8.1.7. We had 12 concurrent processes doing the copying. It used to finish
> within 15 minutes. The copying was done at a period of low activity.
>
> eric

Thanks. It may well be that moving the data across a database linnk works best for the OP given the OP's situation. But database links are known for many things: Speed isn't one of them.

-- 
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)