0

Why is datapump export faster than exp?

closed as primarily opinion-based by a_horse_with_no_name, Mark Storey-Smith, RolandoMySQLDBA, RLF, Max Vernon Nov 10 '14 at 22:10

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

2

Datapump is much more efficient than exp:

Datapump runs within the Oracle server processes, and can read directly from the database files and write directly to a file on the server. As I understand it, data access is direct, not via SQL.

exp uses the ordinary Oracle Call Interface (OCI) -- the library that Oracle provides to connect to the database. It can only run ordinary SQL statements like any other program.

0

Also data pump can run in parallel, and has the option to append data, truncate tables or replace table. In addition you can change table spaces when you import. It is a better utility in every way than the older exp/imp tool.

Not the answer you're looking for? Browse other questions tagged or ask your own question.