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;