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

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Fri, 07 Mar 2003 05:34:03 -0800
Message-ID: <F001.00563132.20030307053403@fatcity.com>

thank u guys.
thanks for letting me know this.

WINDOSEEEEEEEEE :-(((( 7-3-2003 21:53:50, Stefan Jahnke
<Stefan.Jahnke_at_bov.de> wrote:

>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
>---------------------------------------------

-- 
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).

Received on Fri Mar 07 2003 - 07:34:03 CST