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

    Oracle DB corrupted?

      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