Interested to Buy Any Domain ? << Click Here >> for more details...
Explain an ORA-01555
- 2 Answers
- 7045 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 |
Compare and contrast TRUNCATE and DELETE for a table.
what are basic modules required to implement oracle application in any oraganisation?
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?
What is Restricted Mode of Instance Startup in Oracle?
How do you add a data file to a tablespace?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Give the reasoning behind using an index.
What is an Oracle database Partial Backup?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is index? How many types of indexes?
Difference between transaction type and transaction sources. : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
Oracle General 
