topic Re: Ora-21700 Object Does Not Exist Or Is Marked For Delete With ST_GEOMETRY in Data Management Questions

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

EmadAl-Mousa — Fri, 31 Jan 2014 09:00:30 GMT

When trying to drop the SDE user, you are getting the error:

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

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

EmadAl-Mousa — Fri, 31 Jan 2014 09:02:27 GMT

A corruption is introduced in your ArcSDE Geodatabase instance:

1. Try to drop user SDE using drop user cascade command: DROP USER SDE CASCADE;
This will generate error if there are objects created using SDE.ST_GEOMETRY because of dependencies

2. Try to drop the tables in other schemas using the SDE.ST_GEOMETRY type
Get also error ORA-21700: object does not exist or is marked for delete

3. Back to SDE and try to drop the SDE.ST_GEOMETRY type gives error
ORA-21700: object does not exist or is marked for delete

The Cause of this issue:

Dictionary gets corrupted when tables using a specific object type (SDE.ST_GEOMETRY) are tried to be dropped after the type was tried to get dropped

The Solution:

the objects cannot be dropped after this type of corruption is introduced

The objects can be left there and create a new database for this cartridge to be reinstalled or create a new database and do full exp/imp

In order to avoid this problem the objects using the SDE.ST_GEOMETRY type have to be dropped before dropping the SDE schema. Also the drop user SDE cascade should not be used.

my blog reference: http://geodatamaster.wordpress.com/2014/01/31/ora-21700-object-does-not-exist-or-is-marked-for-delete-when-dropping-a-user-with-st_geometry/

ESRI Reference Link: http://support.esri.com/en/knowledgebase/techarticles/detail/34483

Oracle Metal ink reference document number 9876

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

VinceAngelo — Fri, 31 Jan 2014 09:37:06 GMT

This has been discussed before, in the form of actual questions. This practice of posting self-answered questions appears to be a way of publicizing your blog, which is spamming. Please do not spam this Forum.

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

EmadAl-Mousa — Sat, 01 Feb 2014 03:01:51 GMT

First of all my "intentions" is to "share knowledge".......

I checked the forums about this problem "before" posting my thread, and the answer was not written in a systematic way.

This forum has helped me a lot for the last couple of years, and i think i am contributing in it even if its in small amount.

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

VinceAngelo — Sat, 01 Feb 2014 11:47:33 GMT

You "answered" the question in second person, as if you hadn't asked it, then gave yourself MVP points for responding. This is abusive. You could have just posted a discussion thread. And this is the third occurrence of this practice. I understand the desire to help others, but publicizing your blog in this manner crosses the line to helping yourself.