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

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F204CEB.DE344090_at_remove_spam.peasland.com>...
> I've experienced this same "problem" myself, but only on Windows.
> Windows does a nice job of putting file-level locks on anything and
> everything. And yes, I've even had SQL*Plus put a file-lock on a file in
> Windows. Sometimes, you can rename the file. But you can't delete the
> file until all applications locking the file are no longer running. For
> the database theorists out there, this is similar to "strict two-phase
> locking", but I digress.
>
> In my opinion, it's Windows thinking it is smarter than I am and just
> getting in my damned way...
>

That doesn't surprise me in the least. Ah, the crosses one must bear to feed one's family...

Kind regards,
jh Received on Fri Jul 25 2003 - 04:39:47 CDT