RE: Cannot delete datafile from O/S -- Help !!

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 07 Mar 2003 04:48:46 -0800
Message-ID: <F001.00563023.20030307044846@fatcity.com>

Jp,

If you bounce the database (shutdown normal & Startup), you will be able to delete the file. Sometimes, NT (or Oracle on NT) does not immediately release the file. By bouncing the database, you will be able to delete it.

Hop this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, March 07, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L

Guys,

SQL> drop tablespace DATA14 including contents; Tablespace dropped.

the name of the datafile in DATA14 tablespace is DATA141.DBF

SQL>select * from v$tablespace where name = 'DATA14'; no rows selected

SQL>select * from v$tdatafile where name = 'DATA14.DBF'; no rows selected

when i try to delete the file DATA14.DBF from o/s , it says : "Cannot delete DATA14. There has been a sharing violation.The source or destination file may be in use."

why is it so ? how can i delete the file from O/S ? can someone help me ?

the ENV is 8.1.6 / win2k.

TIA.
Jp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 07 2003 - 06:48:46 CST