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

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

internal architecture

0 Answers   CSC,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---