What is the difference between Datapump & export/import?
- 2 Answers
- 11014 Views
- I also Faced
- E-Mail Answers
Answer Posted / kranthi shiva
Datapump is having better performance than export/import
Datapump--it is having byte
it is having parallelism concept
Incremental backups
we can restart the job, kill and resume the job.
Export/Import-- here we cannot resume the job
it is having bit level or block level
it is not having incremental backup
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is transparent data encryption? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you call update statistics? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Explain materialized views and how they are used.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
