why Datapump is faster than traditional export and import

Question Posted / shiva

4 Answers
21313 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

what are the performance views in an oracle rac environment?

0 Answers Oracle,

how can you create a user-defined lock?

0 Answers Oracle,

What does coalescing a tablespace do?

1 Answers

what is meant by gateway

1 Answers IBM,

What column differentiates the V$ views to the GV$ views and how?

3 Answers

why we use cursors

1 Answers

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

what is the difference between db2start command and start database manager command?

1 Answers

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

For more DB Administration Interview Questions Click Here