Re: Export (exp) or Datapump (expdp)

From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 02 Aug 2013 13:43:49 -0600
Message-ID: <51FC0BF5.40102_at_evdbt.com>

Either EXPDP from the source database, or IMPDP from the destination database, using the NETWORK_LINK and PARALLEL parameters. Prevents time, space, and I/Os from being wasted on writing to and reading from intermediate ".dmp" files.

On 8/2/2013 1:37 PM, Bala wrote:
> I have a requirement to copy 80 mllion rows table from PROD to DEV.
> This table is 28 GB in size, has 4 indexes built on its columns.
>
> 11gR2 (11.2.0.3), Linux Redhat 6 environment.
>
> What would be the most optimal way to do it -- use traditional export or
> datapump (expdp) ,any insight will be greatly appreciated.
>
> Thank you all for your time.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 02 2013 - 21:43:49 CEST