删除sde用户问题

删除SDE用户(GIS地图数据用户),长时间删除没反应,结束drop user sde cascade命令后,重新执行,结果报ORA-00604 ORA-21700

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

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

delete from association$ where obj#=114471;

drop user SDE cascade;

原文地址:https://www.cnblogs.com/yansc/p/5944638.html