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.
Dig Deeper on Oracle database design and architecture