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

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 27 Jul 2003 23:50:59 -0700
Message-ID: <73e20c6c.0307272250.4774969f@posting.google.com>

vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0307250412.309a0ece_at_posting.google.com>...
>
> Beg to differ. IMO Windows is working as what is expected (and it has
> borrowed heavily from VMS btw).

Disagree. As the OP said: he's dropped the tablespace and wants to lose the file at OS level. Why the heck is Windows still hanging on to it even though Oracle has obviously closed the file unit?
As soon as a process does fclose(), Windows should release any file locks that process might have held on the file. Yet it doesn't: you can prove that with a little C program in command line mode in Windows.

This is different from the situation you reported in Unix whereby a file can be deleted but is not really until the process last locking it has finished or closed the file unit. That is the correct behaviour, abstracting of course security checks.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Mon Jul 28 2003 - 01:50:59 CDT