Delete user on arcgis server which is oracle

[GorkemKaradogan]

Hi,

I hava a problem, when we delete users, we get error.

You can see my code and error whic is given oracle.

Is there any solution about this problem?

drop user sdedata cascade;

ORA-00604: error occurred at recursive sql level 1

ORA-21700: object does not exist or is marked for delete oracle

[AsrujitSengupta]

Ora-21700 Object Does Not Exist Or Is Marked For Delete  With ST_GEOMETRY

You can move this thread to Managing Data‌ or Geodatabase‌ for better response.

[VinceAngelo]

It is unwise to drop users before their tables have been gracefully removed from the geodatabase metadata catalogs.  Best practice is to remove geodatabase-registered feature classes using ArcObjects/Python, and to remove SDE-registered tables/views using ArcObjects/Python or 'sdetable -o delete'.  If you have corrupted your metadata, it is unlikely you will be able to upgrade the geodatabase before obtaining assistance from Tech Support.

The only time DROP USER ... CASCADE is really appropriate is when you're planning to drop the SDE user as well, but if this is the case, DO NOT DROP 'SDE' BEFORE ALL TABLES WITH SDE.ST_GEOMETRY and SDE.ST_RASTER COLUMNS!  Doing so will corrupt your Oracle instance in a way that can only be "repaired" by dropping the entire database instance.

- V

[GorkemKaradogan]

so what can i do ? i droped 'SDE' before all tables with SRD.ST_GEOMETRY and SDE.ST_RASTER columns.ı search all table these coloums result is empty but i have some object like these columns

[SuleymanARSLAN]

Same things happened to me some times ago. There is no solution. Only way you can restore whole database instance from backup or create new instance.

[VinceAngelo]

Unfortunately, it's time for backups, or since you were doing bulk drops anyway, database creation and data instantiation script execution.