do not do what pando suggested unless otherwise you want to blow the tablespace off.

***ORACLENOTE***

"alter database datafile xxxxx offline drop" is not meant for removing the datafile at all. Its meant for removing datafile with the intention of dropping the tablespace.

******************

I am sorry to say guys. Oracle Don't mention this where the syntax is given as caution and lot people confused with this syntax.