What is the difference between Datapump & export/import?

Answers were Sorted based on User's Feedback



What is the difference between Datapump & export/import?..

Answer / kittu_chintu2005

Export/Import: traditional backup of oracle database, we can't resume the export/import job if we stop the job in middle. We can't attach any job to running job @ exp/imp. We need not to create a file structure @ oracle level

Datapump: It's introduced from 10g. We can resume the datapump job if we stop the job in middle. We can attach a datapump job to running job. We need create file structure @ oracle level and OS level.

Is This Answer Correct ?    16 Yes 4 No

What is the difference between Datapump & export/import?..

Answer / 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

More DB Administration Interview Questions

If CPU is very slow What can u do to speed up?

1 Answers  


how does an oracle clusterware manage crs resources?

0 Answers   Oracle,


What types of replication are supported in sql server? : sql server DBA

0 Answers  


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

0 Answers  


How can we see the database version in os level

6 Answers   Oracle,






How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  


How would you determine who has added a row to a table?

4 Answers  


What are the commands used in dcl? : sql server DBA

0 Answers  


how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,


Categories