impdp import schema very slow ????
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 5 Apr 2007 10:46:47 -0700 (PDT)
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
- Follow-Ups:
- RE: impdp import schema very slow ????
- From: Karla, Srini \(HAS-SAT\)
- RE: impdp import schema very slow ????
- From: Kerber, Andrew W.
Other related posts:
- » impdp import schema very slow ????
- » RE: impdp import schema very slow ????
- » RE: impdp import schema very slow ????
- » RE: impdp import schema very slow ????
- RE: impdp import schema very slow ????
- From: Karla, Srini \(HAS-SAT\)
- RE: impdp import schema very slow ????
- From: Kerber, Andrew W.