Re: Export (exp) or Datapump (expdp)
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 02 Aug 2013 13:43:49 -0600
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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
