René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

drop tablespace

Removes a tablespace. 
drop tablespace ts_users;
If a tablespace is not empty, it cannot be dropped unless including contents is specified. 
drop tablespace ts_users including contents;
The datafiles are not automatically removed from the harddisk unless including contents and datafiles is specified. 
drop tablespace ts_users including contents and datafiles;

drop tablespace ts_users including contents cascade constraints;

Thanks

Thanks to Saqib Mohsin for helping me improve this page.