1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is the difference between Datapump & export/import?

Question Posted / kittu_chintu2005

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

How do you open a cluster administrator? : sql server DBA

0 Answers  

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

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

0 Answers  




SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

what is the role of dip user in our database?

0 Answers  

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

how can you find out if a table can be redefined?

0 Answers   Oracle,

What is the difference between the SQL Loader and IMPORT utilities?

3 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  

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

For more DB Administration Interview Questions Click Here
Categories