【Arcgis】无法删除SDE用户ORA-21700: object does not exist or is marked for delete

SQL> drop user sde cascade;

drop user sde cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-21700: object does not exist or is marked for delete

无法删除sde用户，报错

https://jingyan.baidu.com/article/656db918d6b81be381249cde.html

连接到sys用户
sqlplus / as sysdba
查到user_id

select user_id,username from dba_users where username  = 'SDE';

275
查到对应进程id

select  o.name,a.* from association$ a,obj$ o where a.obj#=o.obj# and o.OWNER# = 275;

删除对应进程id

delete from association$ where obj#=127541;

重新删除可以了

drop user sde cascade

2021年2月18日补充

问题2：删除sde后创建企业级地理数据库报ORA-04043: Object INSTANCES_UTIL does not exist

本处问题是删了后没关catalog，关了后再创建就可以了

那些打不到我的,终将使我强大