I would like to delete or rename an oracle data file called abc.ora in NT server. The database is deleted and the oracle service is shut down. After reboot the NT box, the data file can not be deleted or renamed, I got the error message as follow:
"Cannot rename abc.ora: There has been a sharing violation. The source or destination file may be in use."
Does someone know how to deal with this problem? Please give me some help since this is an urgent issue for us.
Well , IŽd got something like that with my OAS.
Solution could be dangereus to you but to me it worked. Think twice.
The problems is that file is still in your machine memory, though you put the service down.
You should shoot down THE SERVER and then you will be able to delete the file.