All Oracle Error CodesOracle DBA Forum

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
 SubjectReplies
1.RBS not using5
2.Dubious 15555
3.Snapshot too old4
4.ORA-15554
5.INSERT versus CTAS3
6.How to find out the original SQL resulted the E...3
7.SQL Tuning -- large, long-running outer join query3
8.** export excluding some tables3
9. undo tablespace did not release space??3
10.UNDO poll - was undo segments vs. rbs3
11.oracle linux3
12.(no subject)3
13.Setting event 15552
14.query slow in 9i, but not slow in 8i2
15.(no subject)2
16.To set events or not set events, that is the qu...2
17.To set events or not set events, that is the qu...2
18.Tbs READ ONLY and Snapshot too old2
19.fetch across commit1
20.fetch across commit1
21.fetch across commit1
22.fetch across commit1
23.is it possible in pl/sql?1
24."snapshot too old" and undo_retention1
25.How to find out the original SQL resulted the E...1
26.automatic undo mysteries1
27.ORA-01555: snapshot too old: rollback segment n...1
28.ORA-01555: snapshot too old: rollback segment n...1
29.query slow in 9i, but not slow in 8i1
30.Strange snapshot too old during a select statement1