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

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 - 11:52:23 CST