I've dropped some tablespaces I didn't need any more. It worked fine in Oracle. When I tryied to delete unneeded datafiles from operating system directory it gives me an error saying 'cannot delete. file is being used by another process.'
What could be the problem? How do I go about it?