Tag Info

New answers tagged


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.


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 ...

Top 50 recent answers are included