RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.

  • From: "Khanna, Prem" <prem.khanna@xxxxxxx>
  • To: <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <sjaffarhussain@xxxxxxxxx>
  • Date: Thu, 20 Sep 2007 13:58:15 +0530

I agree with Brandon . expdp/impdp is NOT ALWAYS faster than exp/imp . I
have seen it 
many times to be slower than the conventional exp/imp. Better test it .
 
~jp~ 
________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Thursday, September 20, 2007 12:12 AM
To: john.hallas@xxxxxxxxxx; sjaffarhussain@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.



        Just a word of caution - I haven't used datapump a lot, but the
few times I have used it I was very disappointed with its performance -
it took MUCH longer than good old exp/imp.  I don't have time to review
my notes right now and give you the specifics of exactly how I ran it
with my timings and all the bugs and tuning notes I found, but just be
sure to do some research first and beware that it's not necessarily true
that datapump speed > exp/imp speed so test it for your specific
situation - as usual, it depends.
        
        Regards,
        Brandon

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2007