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
David wrote:
> Hi all,
>
> I want to copy all data from a table (which is about 2G size) from
> database A to B (both are 8.1.7, archive log mode, but on different server).
> What is the safest and fastest way to do this? I have some options:
>
> 1) exp/imp
> 2) insert /*+ append */ with nologging, with database link
>
> Which option is better? Or any other ways?
>
> Thanks,
> David
From your choices (1) but look at transportable tablespaces too.
-- 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:01:27 CST