Answer / guest

The most common reason is that the rollback segments are
too small
http://www.cryer.co.uk/brian/oracle/ORA01555.htm

Answer / bezalel

ORA-01555:
-----------
snapshot too old: rollback segment number string
with name "string" too small

Cause:
-------
rollback records needed by a reader for
consistent read are overwritten by other writers

Action:
-------
If in Automatic Undo Management mode, increase
undo_retention setting. Otherwise, use larger rollback segments

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  

---

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

---

Explain prerequisites and post activities of oracle database installation

0 Answers  

---

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 Answers  

---

which one is currently in used software cmpanies.

0 Answers  

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

0 Answers  

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

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

1 Answers  

---