'drop tablespace' produces a file/table lock??

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 25 Jul 2003 15:52:03 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F4917A@lnewton.leeds.lfs.co.uk>

Hi Billy,

you wrote :

>> Thus, it will not be locking a file UNLESS some process specifically
>> stated that in its fileopen()/_fopen() call. Which means that file
>> handle will be locked until the closefile()/_fclose() call.

I have to disagree. The reported behaiviour with sqlplus is one example, I have come across others. Using Delphi or BCB for example. Open a file in the IDE the close it. 9 times out of 10 it cannot be deleted until the IDE is closed. This is the same problem as with sqlplus - and I *think* it is a Windows Bug in the fclose() or locking subsystem - the locks are not released when the file is closed, only (it appears) when the file is closed and the application exited.

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Fri Jul 25 2003 - 09:52:03 CDT