drop tablespace TEST including contents and datafiles;
SQL> select t2.file#,t1.name tablespacename,t2.name from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#; FILE# TABLESPACENAME NAME---------- ------------------------------ -----------