在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;
uj5u.com熱心網友回復：
運行cmd命令，進入sqlplusselect 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.uj5u.com/shujuku/71819.html
標籤：基礎和管理
上一篇：Mysql安裝問題，如圖