why Datapump is faster than traditional export and import

Question Posted / shiva

4 Answers
21377 Views
Mphasis, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

why Datapump is faster than traditional export and import..

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

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

Give two methods you could use to determine what DDL changes have been made.

2 Answers

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

Name two files used for network connection to a database.

5 Answers

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers Infozech, Wipro,

For more DB Administration Interview Questions Click Here