I have a situation where there is a datafile which is associated to a tablespaces say ADMIN_TBS. but the tablespace is dropped by a script and the file is still present. Can anyone suggest how i can remove that file. I cannot risk to manually remove as it may corrupt the db. I ran the alter database admin_tbs drop datafile <filename>; but i get an error saying the tablespace admin_tbs doesnt exist.