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

Hello Daniel,

 I understand this is a new topic for you, but please, be patient.

 I hope, you understand that I am not spending my time benchmarking this approach. I just use it as needed.

 Years ago it was tested and found much more efficient then exp/imp or any other approach.

 About the move I mentioned - It was about 80GB of data, move took between 3-4 hours and run from two machines to central location.

 These results are highly subjective. They would be much better on idle machines and with higher degree of parallelism (I can use only degree of two).

   I would encourage interested users to test and get conclusion themselves.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1076890219.44472_at_yasure...
> Ron wrote:
>
> > Hello Daniel,
> >
> > Yes - many times. I am little bit surprised that you did not utilized
it
> > before. I guess, happens.
> >
> > Mostly did it on Sun hardware. Last time moved about 150M records, not
> > sure about exact time.
> >
> > Regards,
> >
> > Ron
>
> I'll try again ... have you ever moved 2GB across a database link? How
> long did it take?
>
> --
> 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 Mon Feb 16 2004 - 00:03:07 CST