ORA-01555: snapshot too old: rollback segment number with name “” too small
ORA-22924: snapshot too old
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name “” too small
ORA-22924: snapshot too old
| SQL Code: 1555 | SQL State: 72000
The LOB column for this table had an Very less Retention set for fetching undo blocks,modified accordingly.
04:34:25 SQL> select PARTITIONED,SECUREFILE,RETENTION_TYPE,RETENTION_VALUE,PCTVERSION,RETENTION from dba_lobs where TABLE_NAME=’PR_DATA’ and owner=’PRPCDBA’;
PAR SEC RETENTI RETENTION_VALUE PCTVERSION RETENTION
NO NO YES 1800
04:34:57 SQL> alter table PRPCDBA.PR_DATA modify lob(PZPVSTREAM) (pctversion 5);
Table altered.
04:36:17 SQL> alter table PRPCDBA.PR_DATA modify lob(PZPVSTREAM) (retention);
Table altered.
04:36:35 SQL> select PARTITIONED,SECUREFILE,RETENTION_TYPE,RETENTION_VALUE,PCTVERSION,RETENTION from dba_lobs where TABLE_NAME=’PR_DATA’ and owner=’PRPCDBA’;
PAR SEC RETENTI RETENTION_VALUE PCTVERSION RETENTION
NO NO YES 50400