Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

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

1 Answers  

---