Data Pump vs EXP/IMP: Difference or Comparison Between Data Pump Expdp/impdp and Conventional EXP/IMP
Datapump introduced in Oracle 10g whereas conventional exp/imp was used for logical backups in prior versions of oracle 10g. Exp/imp works even in all versions of Oracle.
Conventional exp/imp can utilize the client machine resource for taking the backups but, the datapump works only in server.
XML schema, XML types are supported in expdp/impdp but not in exp/imp
Parallel execution is possible in datapump which is not supported in conventional exp/imp. Using the parallel option the datapump generates multiple dump files simultaneously.
Datapump cannot export the data into sequential medias like tapes.
Datapump has better control than exp/imp on the backup job with START, STOP and RESTART options.
Datapump gives 15 – 50% performance improvement than exp/imp.
Table Extent compression can be done using COMPRESS option whereas in datapump COMPRESSION does the dumpfile compression.