why Datapump is faster than traditional export and import
Answers were Sorted based on User's Feedback
The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.
The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / 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 |
Answer / anonymous
We have parameters like parallel to assign number of workers in data pump, but not in exp/imp.
Also Data Pump uses stream pool of SGA.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rizwan
In traditional datapump exp/imp utility we can not stop the job when it's processing.
whereas in newly expdp/impdp utility we can stop and restart the job
for example, we are exporting the 5 mb size of table and,suppose we want to stop this job so it is possible in expdp but not through exp utility.
| Is This Answer Correct ? | 1 Yes | 1 No |
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
Query processing is slow(eg select query)how will u solve that
How would you determine who has added a row to a table?
Give two examples of referential integrity constraints.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How can we know the exact updation date of a particular database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain materialized views and how they are used.
How would you determine the time zone under which a database was operating?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you go about generating an EXPLAIN plan?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)