2

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.

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

3 Answers 3

2

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

ALTER SYSTEM FLUSH 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 11.2.0.1.0 - 64bit Production
1
  • 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, 2011 at 20:01
1

What does the output of

SELECT OWNER,OBJECT_TYPE
FROM ALL_OBJECTS
WHERE OBJECT_NAME = '<OBJECT NAME FROM SELECT STATEMENT>';

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

0

I have a similar problem it was due a bad character I ran the below request to good name view

select '@'||VIEW_NAME||'@' from user_views;

I copied the view name with @ and replace them by "

DROP VIEW "your_view_name";

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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