drop tablespace including contents and datafiles code example Example: how to remove tablespace in oracle DROP TABLESPACE tbs_02 INCLUDING CONTENTS AND DATAFILES;