Problem:How to drop tablespace if datafile is missing

Impact: data files are missing and you cannot delete tablespace

Solution: Follow these commands
(1)startup mount
(2)alter database datafile '/path/to/filename' offline drop;
(3)alter database open;
(4)drop tablespace tbsp_name including contents cascade constraints;