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

Hello Daniel,

  Yes - many times. I am little bit surprised that you did not utilized it before. I guess, happens.

  It is actually pretty standard technique of moving data between platforms or just moving very big tables across databases (this or CTAS across db_link, same colo or colos with a good link between them)

  Mostly did it on Sun hardware. Last time moved about 150M records, not sure about exact time.

  It always beats exp/imp times ahead (you tell me why ;-)) and has other obvious benefits (like no need to generate huge files, etc).

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:1076886197.912997_at_yasure...
> Ron wrote:
>
> > Hello Daniel,
> >
> > Sorry for not mentioning this - I assume user would use db_link to
select
> > data.
> >
> > Performance wise - I would never use exp/imp vs direct parallel insert
+
> > parallel select across db_link (especially for the big tables).
> >
> > Regards,
> >
> > Ron
>
> 2GB across a database link. Have you actually done this? If you
> have ... how long did it take and on what hardware? If not why
> do you feel competent to make such a recommendation?
>
> --
> 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:29:05 CST