Oracle中删除表空间提示ORA-00604和ORA-21700

[qq_39476296]

在oracle中删除sde用户（用户名为sde1，表空间名为SDE_TBS）时报错，报错的内容一样：
------------------------------------------
ORA-00604:error occurred at recursive SQL level 1
ORA-21700:object does not exist or is marked for delete
------------------------------------------
附：
删除表空间语句是：drop tablespace SDE_TBS including contents and datafiles;
删除用户的语句是：drop user SDE cascade;

[静坐墙角待红杏]

运行cmd命令，进入sqlplus 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;