Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: AW: Cannot delete datafile from O/S -- Help !!

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

From: Turner, Adrian A SITI-ITPSIE <Adrian.A.Turner_at_is.shell.com>
Date: Sat, 08 Mar 2003 03:08:38 -0800
Message-ID: <F001.00563F4D.20030308030838@fatcity.com>


My workaround is to offline the tablespace first; seems to work and havent experienced any issues - but then maybe I'm just lucky. ;-)

-----Original Message-----
Sent: 07 March 2003 15:54
To: Multiple recipients of list ORACLE-L

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: 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: Jared Still
  INET: jkstill_at_cybcon.com

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: Turner, Adrian A SITI-ITPSIE
  INET: Adrian.A.Turner_at_is.shell.com

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 Sat Mar 08 2003 - 05:08:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US