Skip to Main Content

Database Software

Change the ORA-1555 message

Franck PachotOct 22 2015 — edited Jan 11 2016

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
Post Details
Added on Oct 22 2015
9 comments
943 views