Table not dropping for some odd reason
Anyone know why the table isn't dropping? It's not locked and the query shows it exists.
Oracle 11.2.0.4 single instance, Linux 6.7
uat_maven_owner@ot1mg051> drop table access_schema_version cascade constraints purge; drop table access_schema_version cascade constraints purge * ERROR at line 1: ORA-00942: table or view does not exist uat_maven_owner@ot1mg051> select object_name, OBJECT_TYPE from user_objects; OBJECT_NAME OBJECT_TYPE ------------------------------ -------------------------------------------------------------------------------------------- access_schema_version_s_idx INDEX access_schema_version_pk INDEX access_schema_version TABLE uat_maven_owner@ot1mg051> uat_maven_owner@ot1mg051>
0