Interested to Buy Any Domain ? << Click Here >> for more details...
why Datapump is faster than traditional export and import
- 4 Answers
- 21477 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 is transparent data encryption? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can you initialize log miner?
What is the default fill factor value? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what functionality does oracle provide to secure sensitive information?
What happens on checkpoint? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you communicate with operating system files from oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
