RE: how to improve impdp

I do a lot of peoplesoft refreshes and the slowness is usually in the metadata, dropping the user takes a few hours as there is over 25k tables and so does building stats. Working with the ps team has allowed me to export just the tables/views and exclude statistics. On imdp, I drop the views first and then use table_exists_action=replace as ps tables don't have foreign keys. I then let oracle just build up the stats with its nightly job. Process went from 7 hrs to 2.5 and the users are happy with the data.

> From: Joan.Hsieh_at_tufts.edu
> To: steve.harville_at_gmail.com
> CC: ORACLE-L_at_freelists.org
> Subject: RE: how to improve impdp
> Date: Tue, 9 Jul 2013 15:15:32 +0000
>
> We can freeze the AIX production on Friday night, do the expdp, and scp to LINUX, drop the sysadm user cascase on LINUX, re-import (impdp to LINUX database). So there shouldn't be a network issue. Right?
> Joan
>
>
                                                                                              

--
http://www.freelists.org/webpage/oracle-l