SQL> CREATE TABLESPACE OMFTEST2 DATAFILE SIZE 100M; When you delete a table space, you can use the following parameters: SQL> Drop tableSpace OMFTEST2 INCLUDING CONTENTS AND DATAFTEST2 INCLUDING CONTENTS AND DATAFILES; the data file can be completely deleted after the table is removed. And it is the most thorough way to delete data files.
