why Datapump is faster than traditional export and import

Question Posted / shiva

4 Answers
21489 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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

What is the difference between Datapump & export/import?

2 Answers

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

0 Answers

Name two files used for network connection to a database.

5 Answers

Name three advisory statistics you can collect.

1 Answers

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers

What are the steps you will take to improve performance of a poor performing query?

0 Answers

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

what is the use of home directory???

1 Answers HP,

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

what r the types of backup?

5 Answers CSC,

For more DB Administration Interview Questions Click Here