Version 8.1.6 - When I try to create a tablespace it gives me the error saying file exists. [File actually doesn't exist].
When I create tablespace with REUSE option, it creates the tablespace and shows the entry in dba_tablespaces and dba_data_files but when I check in unix file does not exist.