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

one more note:

   After some consideration: use of TTS would make sense only if table occupies most of the tablespace and it is self-contained.

   So, you can ignore it if this is not your case.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Ron" <support_at_dbainfopower.com> wrote in message news:ipCdnUyQAO_LLbLdRVn-sw_at_comcast.com...
> 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
>
> ( for better performance (if machine resources allows) you can
>
> 1) parallelize inserts by adding parallel hint (don't forget "alter
> session enable parallel dml" )
>
> 2) add parallel hint to select to minimize impact on production
> )
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
> "David" <david_at_david.nospam.com> wrote in message
> news:c0o8uh$a8717_at_imsp212.netvigator.com...
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
Received on Sun Feb 15 2004 - 12:02:38 CST