Alter package statement returns ORA-04021

From: <qlos_at_my-deja.com>
Date: Tue, 14 Sep 1999 19:26:23 GMT
Message-ID: <7rm7gj$be$1@nnrp1.deja.com>

When I want to alter package error ORA-04021 occurs:

SQL> alter package constants compile

     2>
alter package constants compile
*
ORA-04021: timeout occurred while waiting to lock object CONSTANTS

Following the error message I was investigating if there is any lock on the package, but there is not. So what the problem can be ????

SQL> select * from v$lock;

ADDR     KADDR           SID TY        ID1        ID2      LMODE
REQUEST      CTIME      BLOCK

-------- -------- ---------- -- ---------- ---------- ---------- ------- --- ---------- ----------

CB1BF6B4 CB1BF6C4          2 MR          8          0
4          0          0          0
CB1BF63C CB1BF64C          2 MR          1          0
4          0          0          0
CB1BF600 CB1BF610          2 MR          2          0
4          0          0          0
CB1BF5C4 CB1BF5D4          2 MR          3          0
4          0          0          0
CB1BF588 CB1BF598          2 MR          4          0
4          0          0          0
CB1BF54C CB1BF55C          2 MR          5          0
4          0          0          0
CB1BF510 CB1BF520          2 MR          6          0
4          0          0          0
CB1BF4D4 CB1BF4E4          2 MR          7          0
4          0          0          0
CB1BF6F0 CB1BF700          3 RT          1          0
6          0          0          0

9 rows selected.

SQL> select * from v$locked_object;

no rows selected

SQL> I would appreciate any advice. Thanks very much !!!

Qlos

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 14:26:23 CDT