impdp import schema very slow ????

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 5 Apr 2007 10:46:47 -0700 (PDT)
Message-ID: <119599.11646.qm@web60821.mail.yahoo.com>

We have ORACLE 10.2.0.2 on LINUX server. I saw ORACLE document say "expdp/IMPDP" performance a lot better than "exp/imp".

I have been tried expdp/impdp schema and found "impdp" performace very slow (at least two to three times long than "imp"). When we do "impdp" it will stay on "Processing object type
SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS" for 20 -30 minutes.

Does anyone know why?

Thanks.  

---

The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php

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

Received on Thu Apr 05 2007 - 12:46:47 CDT