if the datafile doesnt exist in the location, is it not possible to drop a tablespace? the datafile has been dropped accidentaly and i dont need it.
i want to recreate the tablespace with the datafile again.
if i say drop tablespace
, i get error ora-01116 error in opening database file
what to do?