why Datapump is faster than traditional export and import
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is the difference between hot backup n rman backup?
What are the different types of indexes available in sql server? : sql server DBA
what is difference between user managed backup and rman backup?
how can you create a user-defined lock?
What is the importance of a recovery model? : sql server DBA
How would you determine the time zone under which a database was operating?
how can you process messages in order asynchronously?
You're getting high "busy buffer waits" - how can you find what's causing it?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
Name a tablespace automatically created when you create a database.
Explain CREATE DATABASE syntax?