This discussion is archived
9 Replies Latest reply: Aug 29, 2013 2:13 AM by Aman - Oracle RSS

Snapshot too old ORA-01555 from select statement (discoverer)??

scunningham9999 Newbie
Currently Being Moderated

Hi All


Am I loosing the plot .. but we have a select statement run from discoverer which is causing the famous snapshot too old error.


My understanding is that undo is generated from select/insert/update.


So why is the following discoverer Select statement causing the error?
from alert
ORA-01555 caused by SQL statement below (SQL ID: gk0wxgqmx66sh, Query Duration=3866 sec, SCN: 0x001e.089cf3f9):

SELECT  ( ROUND(( TO_DATE(SYSDATE)-o101038.HIRE_DATE )/365,2) ) as

  "  bla bla



Thanks in Advance


  • Correct Answers - 10 points
  • Helpful Answers - 5 points