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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.