DROP TABLESPACE INCLUDING CONTENTS CASCADE CONSTRAINTS
Will give an error
ORA-01561: failed to remove all objects in the tablespace specified

Solution
Step 1:
select ts# from ts$ where name = ‘‘;

Step 2:
update seg$ set type# = 3 where ts#=;
commit;

Step 3
shutdown abort;
startup

Step 4
drop tablespace including contents;

Comments are closed.