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 |
How do you resize a data file?
how can it possibble to see the report output in excel sheet in oracle applications
3. Steps in UAT?
What is db_recovery_file_dest in oracle? When do you need to set this value?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the difference between conversions and interfaces? : oracle accounts receivable
Explain an ORA-01555
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,