Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Can we take incremental backups in datapump?

1 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

Why would you use sql agent? : sql server DBA

0 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

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

3 Answers  

Datapump backup steps?

1 Answers  

What type of index should you use on a fact table?

1 Answers  

what is a user-defined lock?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories