thank u guys.
thanks for letting me know this.
WINDOSEEEEEEEEE :-((((
7-3-2003 21:53:50, Stefan Jahnke
<[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>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:[EMAIL PROTECTED]
>
>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:[EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
>
>
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).