Explain an ORA-01555
- 2 Answers
- 7234 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 |
What is supporting issues GL AP and AR?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
what is correlated subquery
what is debit memo and credit memo in AR?
Give two methods you could use to determine what DDL changes have been made.
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
Where in the Oracle directory tree structure are audit traces placed?
What is Tax Categories?
How would you determine what sessions are connected and what resources they are waiting for?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Oracle General 
