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 |
Which environment variables are absolutely critical in order to run the OUI?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
What are the ways tablespaces can be managed and how do they differ?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
How would you determine who has added a row to a table?
internal architecture
how can you process messages in order asynchronously?
what is rebuild index??
How do you add a data file to a tablespace?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you open a cluster administrator? : sql server DBA