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

getting nonexistent datafile,logfile and tempfile