Unable to drop datafile after dropping tablespace
735967Feb 6 2012 — edited Feb 6 2012Hi 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