Skip navigation

Change the ORA-1555 message

score 420
You have not voted. Active

A very simple idea: please change the message for ORA-1555: snapshot too old: rollback segment number ... with name "..." too small

How many times a user receiving this message just blame the DBA for putting too small rollback segments!

Message should be: query duration beyond undo retention, can't get consistent view.

Comments

Vote history