To drop the tablespace :

To drop the tablespace

:

SQL> 
   alter tablespace "test" offline
;
SQL> /

Tablespace altered.


SQL> drop tablespace "test" including contents and datafiles;



Tablespace dropped