I have got a few feature classes in an SDE connection. This is the situation:
a) They are listed in ArcCatalog (10.1), but the open fails. The message says:
'Error opening feature class, DBMS table not found [ORA-04043: object XXX does not exist]'
b) Obviously, the tool Delete_management cannot be used as the geometry does not exist and it fails too.
c) If you go to your Oracle schema the individual tables corresponding to those geometries are not there, they have been deleted I am afraid and the whole thing makes sense. But under the SDE user, if you open the 'LAYERS' table, the table names are there.
I have read this post, but it does not help me: Delete SDE feature class features with ArcPy
So, in order to clean the database, shall I delete the entry in the LAYERS table and problem solved? what else or what other steps in Oracle are necessary? every time I open ArcCatalog the corrupted layers are listed and I want to remove them completely.
: Delete SDE feature class features with ArcPy