Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best way to copy 2G table data between two databases
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
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: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)
>
Received on Sun Feb 15 2004 - 12:24:33 CST