Answer / nirav gajjar

The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.

Answer / kittu

The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size

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,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

---

What is the difference between Datapump & export/import?

2 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

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

1 Answers  

---

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

1 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---