Home » RDBMS Server » Server Administration » Dropping Tablespace and datafiles
Dropping Tablespace and datafiles [message #206643] Thu, 30 November 2006 23:25 Go to next message
Messages: 1
Registered: November 2006
Junior Member

I have few queries about dropping a tablespace.

- Oracle 10g.
- Windows.

I have a tablespace, say TS1. I have no objects in it. I have to drop the tablespace, as well as the datafiles. To do it I use


This statement drops the tablespace, but the datafiles are sometimes deleted but sometimes not. I checked in some forums and found that whenever the datafiles are not deleted, the error message is written to the alert log. I checked the alert log and found the following errors:

1) ORA-01265: Unable to delete DATA D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\TEMPDATA1\DF_TS1
2) ORA-27056: could not delete file
3) OSD-04024: Unable to delete file.
4) O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

Is there any way to delete the datafile with a single statement?

Re: Dropping Tablespace and datafiles [message #206740 is a reply to message #206643] Fri, 01 December 2006 05:32 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
4) O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

May be there is some Backup session having a hold.
Or some WINDOWS OS utilities are using the file (like a virus scanner or something like that).
THis is not a temporary tablespace. right?
There are several bugs related to this (on windows platforms) and on readonly tablespaces. Please check metalink.
If you can afford,
take trace of controlfile (backup controlfile to trace). See if this datafile is ***really*** a part of the database still.
DO a clean shutdown and startup.
drop again.

Previous Topic: Oracle start/shutdown with non sysdba account
Next Topic: how to create a data base
Goto Forum:

Current Time: Wed Aug 23 22:12:45 CDT 2017

Total time taken to generate the page: 0.21599 seconds