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

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?

I helped an Informatica specialist do it. It took a substantial number of hours, I don't recall exactly how many since he was actually doing it, and we did a number of tests. Informatica has a start/stop option, it keeps track of what's been moved, so you can do it in chunks. V7 hp --> V8 sun. IIRC. Or was it the other way?

jg

--
@home.com is bogus.
http://chandra.harvard.edu/photo/2004/rxj1242/animations.html