Quote Originally Posted by willim
There are several reasons ora-01555 snapshot too old but I think LIAKAT offer key explanation.

U can not say like that!!!!!.

U cannot disappointed a new writer!!! .

better u give ur own solution user only accept wht is working
Willem or Liakat, how should I name you? Next time try use another IP address.

Regarding your solution Willim, since you pointed us to asktom, read carefully this thread

http://asktom.oracle.com/pls/asktom/...:4273981551976


A. UNDO SEGMENT IS SMALL - May be if you are using 8i
B. UNDO RETANTION IS LOW VALUE - May be
C. USER NOT COMMIT THERE TRANSACTION IMMEDIATLY - Wrong, have you heard about fetch across commit?

1. INCREASE THE SIZE OF UNDO TABLESPACE - May be
2. USE SPECIFIC ROLLBACK SEGMENT FOR LARGE TRANSACTION BASICALY BATCH PROCESS - Out of question in Automatic Undo
3. MAKE UNDO_SUPPRESS_ERROR=TRUE - Just make your set transaction statement gets ignore silently, I guess you have never seens this error

alter rollback segment SYSSMU8$ storage (optimal 1M)
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode