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

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)