Can't delete SDE feature class (SQL)

844
3
03-04-2022 12:37 PM
Labels (1)
MKnapp
by
New Contributor

Hi there -

We've got an SDE feature class (that we have full permissions to) that has become corrupted...meaning that it can no longer be truncated, and we cannot delete it as well. 

We've tried deleting via tools in ArcCatalog, and Pro.

We've looked for locks in the SQL Activity Monitor, but there are none. 

Is there a non-desktop process for deleting a feature class outside of Desktop/Pro. 

Have done some looking though Community posts and the consensus seems to be "call tech support".

Thanks.

0 Kudos
3 Replies
ABishop
MVP Regular Contributor
0 Kudos
MKnapp
by
New Contributor

Thanks Amanda.... this isn't quite our issue... we think the feature class has some orphaned locks on it. We're currently looking at ways that we can stop all connections to the database, then identify and clear out the orphaned locks in SQL. 

-Mike

Reinaldo_Cartagena
New Contributor III

Hi, you can use a python script. There is a guide in the following link:

https://desktop.arcgis.com/es/arcmap/10.6/tools/data-management-toolbox/delete-features.htm 

Reinaldo.

0 Kudos