Re: how to improve impdp

From: Steve Harville <steve.harville_at_gmail.com>
Date: Tue, 9 Jul 2013 10:25:34 -0400
Message-ID: <CAGd4=DRVP9nFALiE0_VmT0oRGAsYuAR+MJFB1aYtN79NjgR=hQ_at_mail.gmail.com>



You can eliminate the export and the space required for the export using impdp over a network link. Also you can increase the number of parallel processes. The bottleneck should be the network in this case. A fast network connection is best. You can test it during the week - no downtime required. During the real move you would want to ensure nothing is accessing the source database.

Steve Harville

http://SteveHarville.com

On Tue, Jul 9, 2013 at 10:14 AM, Hsieh, Joan <Joan.Hsieh_at_tufts.edu> wrote:

>
>
> The parameter I used on the impdp as below, do you have any suggestion how
> to improve the impdp time?
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 09 2013 - 16:25:34 CEST

Original text of this message