Oracle Database Discussions

Hi All,

Trying to Drop tablespace with Datafile, command used is as below

drop tablespace tims_db including contents and datafiles;

this was executed successfully, but still the datafile exists... tried dropping from OS, but unable to delete the file... associated trace alert logs are as below

__________________________________________________________________________________________________
Dump file c:\oracle\admin\ocprd\udump\ocprd_ora_4236.trc
Mon Feb 06 03:40:58 2012
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586


Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 4236, image: ORACLE.EXE


*** 2012-02-06 03:40:58.562
*** SESSION ID:(52.7127) 2012-02-06 03:40:58.500
ORA-01259: unable to delete datafile E:\ORACLE\ORADATA\OCPRD\TIMSDB01.DBF
ORA-27056: skgfrdel: 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.
______________________________________________________________________________________________

OS : Windows 2000
DB : Oracle 9i

Please help

Thanks