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 purpose does the model database server? : sql server DBA
how does an oracle clusterware manage crs resources?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you communicate with operating system files from oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is fill factor? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the default port no on which sql server listens? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How do you open a cluster administrator? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What are the different types of indexes available in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?