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

Hello Daniel,

  Good luck with the exercise.

  If you'd need more config details - please send me a message, I'll be glad to provide info.

  BTW: I never argue that TTS approach is a good one as well - In a fact I suggested it first.

  As I mentioned it would work under some conditions and if you can take outage to convert TS to R/O mode and copy datafile across (also as another user mentioned if platforms are the same).

  You approach with CTAS to new TS and moving it across if fine for small/medium tables (but more complex). For a big tables it has potential to overload busy production system since it would add lots of write I/O, not mentioning gigabytes of additional space you may need.

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:1076962276.474672_at_yasure...
> Ron wrote:
>
> > Hello Daniel,
> >
> > I understand this is a new topic for you, but please, be patient.
>
> > Ron
>
> Would you like me to give you a graphic description of what you can
> do with your condescending attitude or can you just use your
> imagination.
>
> I have been in this industry for 35 years, have more than 14 years
> working with Oracle, consult as both a developer and DBA, and teach
> Oracle at a major research university.
>
> When I require instruction from you I will ask. Right now I am
> preparing to have a couple of my students move 80GB across a db-link.
> Want to guess how close they come to 3-4 hours? Want to guess whether
> it is faster than using transportable tablespaces?
>
> --
> 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 - 18:07:20 CST