AnsweredAssumed Answered

Cant Delete ArcSDE ORACLE

Question asked by birdface on May 30, 2016
Latest reply on Sep 20, 2016 by birdface

hi,

We had full working Arcsde 10.4 and we needed to delete all the objects on the database , including arcsde's.

We didn't delete the users .

The goal was to import the fresh data from production.

In the process Arcsde became invalid and from now on we are not able to delete nor repair, so we deleted all object of the user sachems and then tried to delete from the SDE schema but left with 2 objects that cannot be deleted :GDB_ITEMS,ST_DOMAIN STATS.

this is the error we are getting :

 

[30/05/2016 12:02] Evgenia Yertsenkin:

SQL> drop table SDE.GDB_ITEMS cascade constraints;

drop table SDE.GDB_ITEMS cascade constraints

               *

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

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

 

 

SQL> drop type SDE.ST_DOMAIN_STATS force;

drop type SDE.ST_DOMAIN_STATS force

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

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

 

What should we do, do we need to drop and recreate the whole database including ArcSDE or is there a way that we can drop and create only ArcSDE .

it is a very critical issue for us and prompt answer will be much appreciated.

 

iris hadar

IAA

Outcomes