topic Re: Unable to delete a particular Feature Class from SDE in Data Management Questions

Re:Unable to delete a particular Feature Class from SDE

shravaneshshanmugam — Wed, 28 Dec 2011 05:35:13 GMT

Hi
I am unable to delete a particular Feature Class from SDE. When trying to do so, I am able to delete the feature class but when i either refresh the SDE or reopen ArcCatalog, I am getting the feature class back. When i tried to delete the feature class using command prompt, the process is hanging. The command which i used is
sdetable -o delete -t FEATURECLASS_NAME -i "sde:oracle11g:<ORACLE_INSTANCE>:<SCHEMA_NAME>" -u "<SCHEMA_NAME>" -p "<PASSWORD>"

Please provide some solutions to delete this particular feature class from SDE table.
Thanks in advance.

Re: Unable to delete a particular Feature Class from SDE

VinceAngelo — Wed, 28 Dec 2011 10:41:01 GMT

You should not use ArcSDE command-line tools on tables registered with ArcGIS -- All you'll do
is corrupt the ArcGIS registry (which will cause the very problem you're describing). If a table
has been registered with ArcGIS, it should be deleted by ArcGIS. If you've already deleted it,
you need to recreate it (just an object with the same name, not the exact contents), and then
use ArcGIS to delete it properly. If the delete hangs, contact Tech Support for assistance.

- V

Re: Unable to delete a particular Feature Class from SDE

shravaneshshanmugam — Wed, 28 Dec 2011 12:21:07 GMT

Hi

Actually i guess nothing is wrong in using sde command line and moreover i tried with arcgis before using the command line options by right clicking the feature class and selecting delete command. The process was hanging.

I tried several other options also namely
1) Using delete geoprocessing tool
2) Created a python script for deleting the same.
3) Analyze geo processing tool is also not providing any result.

Re: Unable to delete a particular Feature Class from SDE

sapnas — Wed, 28 Dec 2011 12:56:37 GMT

Did you use "sdelayer -o delete" command prior to "sdetable -o delete" command?

Re: Unable to delete a particular Feature Class from SDE

VinceAngelo — Wed, 28 Dec 2011 15:04:06 GMT

It is never necessary to run 'sdelayer -o delete' before 'sdetable -o delete' (and a there
are some good reasons not to do so).

Once the geodatabase registry is corrupted, you really ought to involve Tech Support.
This is especially true when simple table management directives fail or hang. You'll
probably want to check on the status of your last backup and make an extra snapshot
of the current state, just in case future steps cause further harm to database integrity.

- V