[Oracle] Drop tablespace even if file is missing

Olivier | Tips

drop tablespace <tablespace_name> including contents cascade constraints;

If the file is not present anymore, use this command before DROP statement :

alter database datafile '/path/to/the/tablespace/<tablespace_file>'  offline drop;