why Datapump is faster than traditional export and import
Answer Posted / 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 |
Post New Answer View All Answers
What authentication modes does sql server support? : sql server DBA
What is transparent data encryption? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What would you do with an "in-doubt" distributed transaction?
what is the use of recording information about current session?
what are the types of connection load-balancing?
what is the role of dip user in our database?
Can you redefine a table online?
what do you understand by fine-grained auditing?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is logical system in sap basis
What types of replication are supported in sql server? : sql server DBA