Interested to Buy Any Domain ? << Click Here >> for more details...
Explain an ORA-01555
- 2 Answers
- 7077 Views
- I also Faced
- E-Mail Answers
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 |
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
what is difference between inner join & nested query or subqueries
How would you determine what sessions are connected and what resources they are waiting for?
What is Virtual Memory?
Differentiate between transaction type and transaction source? : oracle accounts receivable
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is supporting issues GL AP and AR?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what is the difference b/w oracle8i and oracle9i
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the disk migration? what is the steps involved in oracle disk migration?
Oracle General 
