删除sde用户问题

删除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;

posted on 2016-10-10 09:36 Anders' Yan 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/yansc/p/5944638.html