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.