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.
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
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-lReceived on Tue Jul 09 2013 - 16:25:34 CEST