exp/imp vs expdp/impdp or datapump export/import feature or difference between datapump and original export/import

prior to oracle 10G, the logical backup was taken through EXP/IMP utility, which was the basic export/import utility till oracle 9i. Oracle has come with more powerful logical backup tool in oracle 10G. As we know about datapump export/import utility.

let us check the feature which enhances the datapump export/import over the original export/import

expdp/impdp(datapump) vs exp/imp(basic one)

1) Impdp/Expdp uses parallel execution rather than a single stream of execution. this improved the task performance a lot.

2) In Data Pump, expdp full=y and then impdp schemas=HR is same as of expdp schemas=HR and then impdp full=y where in original export/import does not always behave the same.

3) in datapump Expdp/Impdp access files on the server rather than on the client.

4) Data Pump represents metadata information in the dump file set as XML documents rather than as simple DDL commands.

5) Datapump Impdp/Expdp has self-tuning abilities. Tuning parameters that were used in original Export and Import, such as RECORDLENGTH and BUFFER are not supported by
Data Pump Export and Import.Not required is the perfect term to define.

6) Datapump Expdp/Impdp operates on a group of files called a dump file set rather than on
a single sequential dump file as exp/imp

7) Oracle data pump does not supports Sequential media, such as tapes and pipes.

8) The way of transition of data between two different versions of oracle database is not same
in expdp/impdp and exp/imp utility

9) When you are importing rows into an existing table using either APPEND or TRUNCATE
using datapump, if any row violates an active constraint, the load is discontinued and no data is loaded.

Original Import will logs any rows that are in violation and continues the load process.

10) Datapump expdp/impdp generates more undo than expdp/impdp

Hope the information are useful....

thanks,
have a nice day.............