Dropping Tablespace including datafile
550474Feb 26 2009 — edited Feb 26 2009Hi,
In my laptop, i am using oracle 9i for learning purpose. Previously i had created table space for statpack. Now i had dropped all users related to statspack tablespace and tried to drop the tablespace including datafile. The drop including datafile command executed successfully. But the physical file was not deleted. Error logged in alert log file is
ORA-01259: unable to delete datafile D:\ORACLE\ORADATA\TEST\TEST_STATSPACK.ORA
ORA-27056: could not delete file
OSD-04024: Unable to delete file.
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
shall i delete the physical file manually with o/s commands after shutting down db or else any other steps to be performed???
Thanks in advance.