Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table that definitely exists in the logged-in user's schema (therefore I own the table) and is not a view/synonym/anything wacky.

I can select from it, but when I try and either insert, update or delete from this table, I get

ORA-00942: table or view does not exist

I'm completely baffled.

share|improve this question
Anything in the alert log, like an ORA-600 or -7445? – Gaius Nov 16 '11 at 15:01
I see nothing in the alert log. – Glenn Moss Nov 16 '11 at 15:04
Any trigger on the table? – a_horse_with_no_name Nov 16 '11 at 15:31
No triggers either. – Glenn Moss Nov 16 '11 at 16:43
@JoeChin IF the user really does own the object as stated in the question then this answer can't be correct. – Niall Litchfield Nov 17 '11 at 9:00

Once I had a similar Problem. To shorten a rather long story, just flush your shared pool.


Somehow Oracle seems to create an corrupted entry in the statement cache. Problem has been resolved after flush. After that, we were unable to reproduce it.

You need some administrative privileges to flush it.

One final note: ORA-00942 does not exist in the database documentation at all.

According to my notes, we used this Oracle version.

Oracle Database 11g Enterprise Edition Release - 64bit Production
share|improve this answer
I'm definitely interested to try this if I ever have the problem again. I'm not sure what got it into that state in the first place... – Glenn Moss Dec 27 '11 at 20:01

What does the output of


show (assuming you don't want to give us the object name).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.