Database Administration (MOSC)

MOSC Banner

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> 



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center