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

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-l

Received on Tue Jul 09 2013 - 20:44:55 CEST