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

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

 

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

ERROR:

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

SOLUTION:

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

 

For more such weblogic issues and resolution click here.

Latest Weblogic Interview Questions and Answers

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

  1. Pingback: How to find out if the order is stuck in resequencer or not? - CloudNClear

Comments are closed.