This discussion is archived
11 Replies Latest reply: Feb 7, 2013 11:41 AM by jgarry RSS

Oracle DB corrupted?

800411 Newbie
Currently Being Moderated
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


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