How To Drop a Tablespace?

If you have an existing tablespace and you don't want it anymore.
You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below.

SQL> CREATE TABLESPACE my_space DATAFILE '/d01/oracle/oradata/prod/myspace.dbf' SIZE 100M;

Tablespace created.

SQL> drop tablespace my_space;

Tablespace dropped.

SQL>