Explain an ORA-01555

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

3. Steps in UAT?

2156


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.

1831


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2120


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

995


Are These Dff's Flexible?

903


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1999


What is Restricted Mode of Instance Startup in Oracle?

882


what are the tools used for oracle 10g in real time.

2148


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

808


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7145


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

995


as a technical developer in oracle applications which type errors feced in your experience sofar

2090


What is chargeback invoice? How do we create it? : oracle accounts receivable

1013


can we use lexical perameter in oracle plsql if yes how

2058


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

877