Explain an ORA-01555
Answers were Sorted based on User's Feedback
Answer / guest
The most common reason is that the rollback segments are
too small
http://www.cryer.co.uk/brian/oracle/ORA01555.htm
Is This Answer Correct ? | 1 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how to write customizations in po
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is an Oracle database Full Backup?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
what are the advantages of Oracle over other databases..? please give me reply...
What are the main diff. between oracle 7.3 and oracle 8i?
1. What is PO rate variance gain and loss?
How would you determine what sessions are connected and what resources they are waiting for?
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,