ORA-00604 ORA-21700错误处理

今天删除SDE用户（GIS地图数据用户）报ORA-00604 ORA-21700，详细处理步骤如下：SQL> 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 deleteSQL> select user_id,username from dba_users where username = "SDE"; USER_ID USERNAME
---------- ------------------------------
123 SDE

SQL> select o.name,a.* from association$ a,obj$ o where a.obj#=o.obj# and o.OWNER# = 123;
NAME OBJ# PROPERTY INTCOL# STATSTYPE# DEFAULT_SELECTIVITY DEFAULT_CPU_COST DEFAULT_IO_COST DEFAULT_NET_COST INTERFACE_VERSION# SPARE2
------------------------------ ---------- ---------- ---------- ---------- ------------------- ---------------- --------------- ---------------- ------------------ ----------
ST_GEOMETRY 114471 2 114478 2 0SQL> delete from association$ where obj#=114471;1 row deleted.SQL> drop user SDE cascade;User dropped.--------------------------------------分割线 --------------------------------------在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址