删除SDE用户报ORA-00604 ORA-21700
引自:https://jingyan.baidu.com/article/656db918d6b81be381249cde.html
删除SDE用户(GIS地图数据用户),结果报ORA-00604 ORA-21700。
解决方法:
1、执行语句: select user_id,username from dba_users where username = 'SDE';
2、根据对应的检索值,执行命令:select o.name,a.* from association$ a,obj$ o where a.obj#=o.obj# and o.OWNER# = 123;
3、删除对应进程:delete from association$ where obj#=114471;
4、重新执行删除命令:drop user SDE cascade;,成功删除