ORA-01555 Snapshot too old error on 10g

[tomcat]

There are several articles on Metalink on LOBs, seems the rollback for LOBs is stored with the LOB (which makes sense).

Check these out:

452341.1
66431.1
162345.1