why Datapump is faster than traditional export and import
Answer Posted / 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 |
Post New Answer View All Answers
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 functionality does oracle provide to secure sensitive information?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the commands used in dcl? : sql server DBA
what is a crs resource?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you enable flashback feature?
What happens on checkpoint? : sql server DBA
which background process invoke at the time of upgradation tell me???
What is a system database and what is a user database? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the recovery models for a database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the importance of a recovery model? : sql server DBA