-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
ORA - 00604: an error occurred at recursive SQL level 1
ORA - 21700: the object does not exist or is marked for the delete
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Add:
Deleted tablespace statement is: drop in tablespace SDE_TBS o contents and datafiles;
Delete user statement is: drop the user SDE cascade;
CodePudding user response:
Run the CMD command, enter up sqlplusThe select user_id, username from dba_users where username='SDE';
According to the corresponding retrieval values, execute the command: select o.n ame, a. * from association of $a, $o where obj a.o bj#=o.o bj# and o.o WNER#=123;
Delete the corresponding process: delete from association $where obj#=114471;
To perform the delete command: drop the user SDE cascade;