|
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.
|
