Home > database >  Oracle deleted tablespace prompt ORA - 00604 and ORA - 21700
Oracle deleted tablespace prompt ORA - 00604 and ORA - 21700

Time:09-24

Delete in oracle sde user (user name sde1, table space named SDE_TBS) times wrong, the content of the error:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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 sqlplus
The 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;
  • Related