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

ORDER BY o101020.SUB_ORGANIZATION_NAME ASC

 

Thanks in Advance

Legend

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