Drop Tablespace and Datafiles associated with it.

1. Ouery to Drop a Tablespace.


SQL> DROP TABLESPACE users INCLUDING CONTENTS;





2.Query To delete the tablespace & datafiles associated with a tablespace


SQl> DROP TABLESPACE users INCLUDING CONTENTS AND DATAFILES;



Oracle Docs Link For reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces009.htm