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 do you understand by fine-grained auditing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the recovery models for a database? : sql server DBA
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
How to start SQL Server in minimal configuration mode?
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 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.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between clustered and non-clustered index? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you find out if a table can be redefined?
What happens on checkpoint? : sql server DBA
what is a crs resource?