why Datapump is faster than traditional export and import
- 4 Answers
- 20143 Views
- Mphasis, I also Faced
- E-Mail Answers
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What the different components in replication and what is their use? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you record information about current session?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
what are the benefits of flashback feature?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what do you understand by fine-grained auditing?
Can you redefine a table online?
