Re: how to improve impdp
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 9 Jul 2013 14:44:55 -0400
Message-ID: <CAGurbTOGCG=fiX=fUix_Lji9LWuWri+eX=oxWfAfFxLx46vXfw_at_mail.gmail.com>
If it takes too long, How about
Date: Tue, 9 Jul 2013 14:44:55 -0400
Message-ID: <CAGurbTOGCG=fiX=fUix_Lji9LWuWri+eX=oxWfAfFxLx46vXfw_at_mail.gmail.com>
If it takes too long, How about
1. drop FKs 2. truncate tables 3. drop all objects owned by schema 4. import ( exclude=index,constraint,statistics transform=storage:n,oid:n ) 5. run your modified index creation script to create indexes in parallel,set to noparallel later
6. run constraint creation script (with enable novalidate if possible) 7. import stats 8. recompile 9. crack open beer
On Tue, Jul 9, 2013 at 2:31 PM, Hsieh, Joan <Joan.Hsieh_at_tufts.edu> wrote:
> "Drop user sysadm cascase" on the new LINUX server take almost the whole
> day to finish. That's another issue.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 09 2013 - 20:44:55 CEST