raghud,

Perform an offline drop of the datafile(s) associated with that datafile and tablespace...

Start the instance

mount the controlfiles

alter database datafile 'fully qualified datafile name' offline drop;

open database