sde for Oracle10g 64bit 删除 SDE用户无法删除的问题
————————————————————————————————————————————————————————————
C:\Users\liheng>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 7 16:22:58 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn sys/sys@orcl as sysdba
已连接。
SQL> drop user sde cascade;
drop user sde cascade
*
第 1 行出现错误:
ORA-00604: 递归 SQL 级别 2 出现错误
ORA-21700: 对象不存在或标记为删除
SQL> select owner,queue_table from dba_queue_tables where owner='SDE';
未选定行
SQL> select user_id,username from dba_users where username = 'SDE';
USER_ID USERNAME
---------- ------------------------------
100 SDE
SQL> select o.name,a.* from association$ a,obj$ o where a.obj#=o.obj# and o.OWNER# = 100;
NAME OBJ# PROPERTY INTCOL# STATSTYPE#
------------------------------ ---------- ---------- ---------- ----------
DEFAULT_SELECTIVITY DEFAULT_CPU_COST DEFAULT_IO_COST DEFAULT_NET_COST
------------------- ---------------- --------------- ----------------
INTERFACE_VERSION# SPARE2
------------------ ----------
ST_GEOMETRY 78269 2 78319
2 0
SQL> delete from association$ where obj#=78269;
已删除 1 行。
SQL> drop user SDE cascade;
drop user SDE cascade
*
第 1 行出现错误:
ORA-01940: 无法删除当前连接的用户
SQL> drop user SDE cascade;
drop user SDE cascade
*
第 1 行出现错误:
ORA-01940: 无法删除当前连接的用户
SQL> drop user SDE cascade;
用户已删除。
SQL>
————————————————————————————————————————————————————————