Oracle-L: AW: Cannot delete datafile from O/S -- Help !!

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Fri, 07 Mar 2003 04:53:50 -0800
Message-ID: <F001.00563054.20030307045350@fatcity.com>

Hi Khanna(?)

Happens alot. Windows still holds a handle to the file. Just wait 'till next scheduled reboot (shouldn't be too long;).

Regards,
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: stefan.jahnke_at_nospam.bov.de
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:andrea.palluck_at_bov.de.

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above.

-----Ursprungliche Nachricht-----
Von: Prem Khanna J [mailto:jprem_at_kssnet.co.jp] Gesendet: Freitag, 7. Marz 2003 11:54
An: Multiple recipients of list ORACLE-L Betreff: Cannot delete datafile from O/S -- Help !!

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: Stefan Jahnke
INET: Stefan.Jahnke_at_bov.de

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