Skip to main content

Posts

Showing posts from May, 2014

Exp / Imp Vs. Expdp / Impdp in Oracle Database

Advantages of DataPump Expdp & Impdp : Data Pump Export and Import operations are processed in the database as a Data Pump job, which is much more efficient that the client-side execution of original Export and Import.  Data Pump operations can take advantage of the server’s parallel processes to read or write multiple data streams simultaneously. Data Pump differs from original Export and Import in that all jobs run primarily on the server using server processes. These server processes access files for the Data Pump jobs using directory objects that identify the location of the files. The directory objects enforce a security model that can be used by DBAs to control access to these files. Datapump has a very powerful interactive command-line mode which allows the user to monitor and control Data Pump Export and Import operations.Datapump allows you to disconnect and reconnect to the session Because Data Pump jobs run entirely on the server, you can start an export or impor