What is the difference between Datapump & export/import?
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 would you do with an "in-doubt" distributed transaction?
What are the recovery models for a database? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Where would you look for errors from the database engine?
what is a user-defined lock?
what functionality does oracle provide to secure sensitive information?
what is grd?
who owns the operating system files created by the utl_file package?
What authentication modes does sql server support? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you schedule a job in database?
What are the new features in sql server 2005 when compared to sql server 2000? : 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