Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'drop tablespace' produces a file/table lock??

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

From: Yong Huang <yong321_at_yahoo.com>
Date: 27 Jul 2003 15:26:26 -0700
Message-ID: <b3cb12d6.0307271426.60daad0a@posting.google.com>


Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F214756.B5095164_at_remove_spam.peasland.com>...
> I've also seen it with DLL files and Oracle Forms and Reports. When
> running a Forms application, accessing centrally located Forms and
> Reports DLL files, a lock was placed on the file. In some extreme cases,
> we've had to reboot the end user's workstations. Big pain in the....when
> dealing with Windows and its file locking.
>
> Cheers,
> Brian

Brian,

Have you tried nthandle? I think it's just called handle now. I can't do much useful work on Windows without a dozen tools downloaded from sysinternals.com. This tool can tell you what process locks a given file. You simply kill the process and the file lock is gone.

Note that you can't install these tools on end users' workstations unless you can write to %systemroot%\system32. I don't understand this requirement.

Yong Huang Received on Sun Jul 27 2003 - 17:26:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US