topic Re: Delete user on arcgis server which is oracle in Data Management Questions

Delete user on arcgis server which is oracle

GorkemKaradogan — Wed, 26 Nov 2014 10:30:49 GMT

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

Re: Delete user on arcgis server which is oracle

AsrujitSengupta — Wed, 26 Nov 2014 18:47:26 GMT

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.

Re: Delete user on arcgis server which is oracle

VinceAngelo — Wed, 26 Nov 2014 21:17:07 GMT

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

Re: Delete user on arcgis server which is oracle

GorkemKaradogan — Thu, 27 Nov 2014 07:45:01 GMT

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

Re: Delete user on arcgis server which is oracle

SuleymanARSLAN — Thu, 27 Nov 2014 08:40:48 GMT

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.

Re: Delete user on arcgis server which is oracle

VinceAngelo — Sat, 29 Nov 2014 05:29:21 GMT

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