Interested to Buy Any Domain ? << Click Here >> for more details...
why Datapump is faster than traditional export and import
- 4 Answers
- 21545 Views
- Mphasis, I also Faced
- E-Mail Answers
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 would you do with an "in-doubt" distributed transaction?
how can you record information about current session?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is dbcc? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where do you find the default index fill factor and how to change it? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you create a user-defined lock?
Query processing is slow(eg select query)how will u solve that
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is dcl? : sql server DBA
What is the default fill factor value? : sql server DBA
