Page 1 of 1

Exp/Imp vs Expdp/Impdp

Posted: Sat May 21, 2011 5:30 am
by Kashif
Dear Fallows.

I want to know the Difference between the 2 utilities provided by the Oracle available in 10g.
Which is better and efficient.
Please suggest me that which utility i have to use for daily backup purpose.
OS Win2003,
DB 10g rel2

Thank and regards.

Posted: Sun Jun 12, 2011 11:40 pm
by amirtai
Hi there

First of all Oracle never recommends or supports Export dump as a backup strategy you have to use RMAN for that purpose.

As far as the efficiency is concerned the Expdp has been proved better than conventional Exp and Imp. Also Data pump is the only utility that Oracle promised to support in their future releases.

Amir