Re: Lock Deleting

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 26 Jun 2005 23:55:17 -0700
Message-ID: <1119855325.944632@yasure>

Zephyr wrote:
> Hi,
>
> my IDE has crashed while debugging a PL/SQL Procedure. After some fixes
> I want to replace the procedure now, but there is a lock on the provedure
> that prevent me from replacing
>
> ORA-04021: timeout occurred while waiting to lock object PRC_AUTOVAL
>
> How can I get rid of the lock?
>
> Thanks
> Patrick

Assuming the worst and given that you have provided no useful information related to Oracle version, operating system, which IDE tool, or anything else ....

SHUTDOWN ABORT
STARTUP
SHUTDOWN IMMEDIATE
STARTUP

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Jun 27 2005 - 01:55:17 CDT