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?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the importance of a recovery model? : sql server DBA
what is the role of dip user in our database?
what is asm?
what are the benefits of flashback feature?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the recovery models for a database? : sql server DBA
internal architecture
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
how to restore files with rman?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you implement fine-grained auditing?