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

From: Bob Jones <email_at_me.not>
Date: Sun, 15 Feb 2004 18:10:57 GMT
Message-ID: <ba1900d1e7a5cf73c6af1434f34fdffd@news.teranews.com>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1076868183.915395_at_yasure...
> Ron wrote:
>
> > Hello David,
> >
> > Also, you can use transportable tablespaces approach ( requires
> > maintenance window since tablespace should be placed into r/o mode,
IMHO -
> > would not use it for 2GB)
> >
> > #2 is a good one
> >
> > Ron
>
> And exactly how does an insert statement get data from one database
> into another? Send 2GB to a spool file?
>
> --
> 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)
>

As he said, through a database link. Received on Sun Feb 15 2004 - 12:10:57 CST