Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best way to copy 2G table data between two databases

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

From: David <david_at_david.nospam.com>
Date: Mon, 16 Feb 2004 04:41:18 +0800
Message-ID: <c0olh4$a8018@imsp212.netvigator.com>


Hi Daniel,

    TT seems not OK since this tablespace contains other tables. What are the disadvantages in using database link to transfer the data?

Thanks,
David

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1076868040.714940_at_yasure...
> 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 - 14:41:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US