Re: how to improve impdp
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 9 Jul 2013 11:04:47 -0400
Message-ID: <CAGurbTOmF99OkE-HH6m67VONOCd7OJkksneFDxFoCGDE1o4MkQ_at_mail.gmail.com>
Joel,
It will work but will not give you any performance boost. Even in 12c I have not seen any tweaks to make this happen automatically in IMPDP. EXPDP and IMPDP will obey settings on objects "as is" which is the beauty (and a curse when we do remap for plsql code). So, you must take manual steps if you want to enhance the performance of indexes and constraints while performing impdp.
Date: Tue, 9 Jul 2013 11:04:47 -0400
Message-ID: <CAGurbTOmF99OkE-HH6m67VONOCd7OJkksneFDxFoCGDE1o4MkQ_at_mail.gmail.com>
Joel,
It will work but will not give you any performance boost. Even in 12c I have not seen any tweaks to make this happen automatically in IMPDP. EXPDP and IMPDP will obey settings on objects "as is" which is the beauty (and a curse when we do remap for plsql code). So, you must take manual steps if you want to enhance the performance of indexes and constraints while performing impdp.
On Tue, Jul 9, 2013 at 10:53 AM, Patterson, Joel <jpatterson_at_entint.com>wrote:
> For this scenario can you not just impdp the tables, then impdp a second
> time for everything except for the tables?
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 09 2013 - 17:04:47 CEST