What is the difference between Datapump & export/import?
Answers were Sorted based on User's Feedback
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 |
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 |
If CPU is very slow What can u do to speed up?
how does an oracle clusterware manage crs resources?
What types of replication are supported in sql server? : sql server DBA
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
How can we see the database version in os level
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
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.
Where in the Oracle directory tree structure are audit traces placed?
What is the recommended interval at which to run statspack snapshots, and why?
How would you determine who has added a row to a table?
What are the commands used in dcl? : sql server DBA
how can you get actual data change values from previous transactions in oracle?