1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

why Datapump is faster than traditional export and import

Question Posted / shiva

Answers were Sorted based on User's Feedback



why Datapump is faster than traditional export and import..

Answer / nirav gajjar

The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.

The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.

Is This Answer Correct ?    18 Yes 1 No

why Datapump is faster than traditional export and import..

Answer / kittu

Datapump has self tuning utilities where as in Exp/imp we need to specify the tuning parameters like buffer & record_length.

While doing datapump job data doesn't travel through the network, it will be done in server side only, so no data transformation through network

Is This Answer Correct ?    12 Yes 3 No

why Datapump is faster than traditional export and import..

Answer / anonymous

We have parameters like parallel to assign number of workers in data pump, but not in exp/imp.
Also Data Pump uses stream pool of SGA.

Is This Answer Correct ?    1 Yes 0 No

why Datapump is faster than traditional export and import..

Answer / rizwan

In traditional datapump exp/imp utility we can not stop the job when it's processing.
whereas in newly expdp/impdp utility we can stop and restart the job
for example, we are exporting the 5 mb size of table and,suppose we want to stop this job so it is possible in expdp but not through exp utility.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB Administration Interview Questions

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

How many memory layers are in the shared pool?

3 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  




Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

what is the use of ocr?

0 Answers   Oracle,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

internal architecture

0 Answers   CSC,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

For more DB Administration Interview Questions Click Here
Categories