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

I have not seen DP performance problems...

I have used it to migrate a E-Business Suite database, around 500GB. With exp it took days, with expdp it took hours. Whem import imp never ends (well cut off after 4 days) and impdp took around 24 hours.

Thanks

--
LSC


On 9/19/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:


>

>  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

>

>  ------------------------------

> *From:* oracle-l-bounce_at_freelists.org [mailto:

> oracle-l-bounce_at_freelists.org] *On Behalf Of *John Hallas

>

>  Once you get to 10g on HP you can use datapump which is much faster

>

> Privileged/Confidential Information may be contained in this message or

> attachments hereto. Please advise immediately if you or your employer do not

> consent to Internet email for messages of this kind. Opinions, conclusions

> and other information in this message that do not relate to the official

> business of this company shall be understood as neither given nor endorsed

> by it.

>


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