Delete Tablespace

You can use following command to remove tablespace from your database.

In my example I want to remove my_tbs tablespace.

DROP TABLESPACE my_tbs INCLUDING CONTENTS AND DATAFILES;