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.
-- 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.