11 Replies Latest reply: Feb 7, 2013 1:41 PM by jgarry RSS

    Oracle DB corrupted?

    mycoffee
      Recently we have a weird thing happens in our Oracle
      Queries to the views return "ORA-00942: table or view does not exist" unless there are a where clause

      select * from VIEW1 failed
      select * from VIEW1 where 1 = 1 works

      What happening? and how we can fix it?

      Thank you