ORA-01555: snapshot too old: rollback segment number with name “” too small

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

Leave a Reply