Drop tablespace in oracle db

Drop tablespace in oracle db

-- Drop a tablespace without removing the physical database files.
 SQL
DROP TABLESPACE TESTING;

TABLESPACE dropped. SQL
SELECT file_name
FROM dba_data_files
WHERE tablespace_name='TESTING';

NO ROWS selected -- Drop tablespace including the physical datafiles.
 SQL
DROP TABLESPACE TESTING INCLUDING CONTENTS
AND datafiles;

TABLESPACE dropped.