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
how can you record information about current session?
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?
What types of replication are supported in sql server? : sql server DBA
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?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you get actual data change values from previous transactions in oracle?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different ways you can create databases in sql server? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How do you open a cluster administrator? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA