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 are the benefits of flashback feature?
what is the diffrence between core dba and apps dba?
What the different types of replication and why are they used? : sql server DBA
Can you redefine a table online?
Explain the use of table functions.
Give the reasoning behind using an index.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
when does an alert gets signaled?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent