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

From: Khanna, Prem <prem.khanna_at_eds.com>
Date: Thu, 20 Sep 2007 13:58:15 +0530
Message-ID: <067233AAA08D3C45BFE7E0864743774203F23DA3@intpm231.apac.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: Thursday, September 20, 2007 12:12 AM To: john.hallas_at_bjss.co.uk; sjaffarhussain_at_gmail.com; oracle-l_at_freelists.org
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

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

Received on Thu Sep 20 2007 - 03:28:15 CDT