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

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...

Cheers,
Brian

Jared wrote:
>
> Just had an interesting problem and wondered if anyone knew the why of
> it - I just dropped a tablespace. Went to delete the file at the OS
> level (I'm in 8.1.7.4.1 on Win2K) and Windoze wouldn't let me - said
> there was a sharing violation. I've only done this a gazillion times
> in *nix and other OS'. Closing the SQL*Plus session that I had used
> to drop the tablespace released whatever lock there was; presumably
> ORACLE.EXE had a lock on the datafile until I exited SQL*Plus.
>
> When I was a VAXcluster manager several decades and a marriage ago,
> one could create one's own message classes. Many had a 'WTF' class
> (one leaves it to the reader to parse out the acronym); and any error
> not otherwise trapped returned something like "WTF - what are you
> trying to do?" to the unfortunate user. This just seems like one of
> those situations.
>
> If anyone knows definitively what was going on I'd appreciate hearing
> about it.
>
> TIA -
>
> Best regards,
> jh

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"