Printable View
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?
I am not sure if it is the same thing. But we dropped tablespaces once, and deleted the datafiles, and we could still not see the space recovered on the OS. Our sys admin suggested we restart the db and the space got recovered.
Alternatively fuser (on unix ) shows who is using a certain file or process.
Good luck
nirasha
Hi,
One of the oracle server processes must have opened that file and till the process ends it will keep the file pointer. The best way is to stop and start the application. Then you should see the space back in the filesystem.
Baliga