RE: Deleting files on w2k

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Tue, 04 Dec 2001 07:21:54 -0800
Message-ID: <F001.003D48C3.20011204061021@fatcity.com>

>> From: "Koivu, Lisa" <lisa.koivu_at_efairfield.com>
>> Date: Fri, 30 Nov 2001 14:48:55 -0600
>> Subject: Deleting files on w2k
>>
>>
>>I'm trying to test out backup and recovery on w2k. However, I can't
remove
>>or rename a file while the database is running! It says "file in use".
>>
>>Am I missing something or is there a way to force this?

Lisa,

As has been mentioned NT/W2K is only brill at putting locks on files which can prove to be a real pain in the ...

Anyhow apart from advice offered to date I'd add there are some useful free utilities to be found at www.sysinternals.com which can be used to identify whats got locks on what files. If for nothing more than curiosity. Also take a look at the Resource Kit utilities.

I have experienced W2K asserting a file is in use by another process and not being able to figure out what that process was or how to kill it's "lock".

HTH,

Sean O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: Sean.ONeill_at_organon.ie

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Dec 04 2001 - 09:21:54 CST