Though this is how it works on NT, I was pleasantly surprised the other day when I was able to delete the files from a tablespace that had just been dropped on Win2k.
Jared On Friday 07 March 2003 04:53, Stefan Jahnke 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: Jared Still 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).
