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.

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

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---