Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'drop tablespace' produces a file/table lock??
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
![]() |
![]() |