You should not be dropping the datafile. The correct way is to drop the tablespace and then remove the datafiles from the OS.

Check this thread --

http://dbasupport.com/forums/showthr...?threadid=6697


- Rajeev