Q
Problem solve Get help with specific problems with your technologies, process and projects.

Unable to select or drop a table

While selecting and dropping a table I'm getting error ORA-00942: "Table or view doesn't exist." I have checked the spelling, schema and object privileges and everything is in place. The table is there but I'm not able to select or drop it.

While selecting and dropping a table I'm getting error ORA-00942: "Table or view doesn't exist." I have checked the spelling, schema and object privileges and everything is in place. The table is there but I'm not able to select or drop it. What could be possible causes of a problem like this?
To drop a table, you must own the table or you must have the DROP ANY TABLE system privilege. You will need to verify that the one of the following conditions is true.

If the above holds, then I would suggest that one of two conditions exist. Either the table has a mixed-case spelling or the table is not a table at all, but rather a view or synonym.

Query DBA_OBJECTS for the object name. The OBJECT_TYPE will tell you if this is a table or not. If DBA_OBJECTS returns the OBJECT_NAME in mixed case, then enclose the table name in double quotes to drop it.

This was last published in September 2005

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close