Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04021 Error while recreating a Package
ORA-04021 Error while recreating a Package [message #191435] Wed, 06 September 2006 06:31 Go to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi,

While recreating a package
I am getting ORA-04021: timeout occured while waiting to lock object <SchemaName>.<PackageName>

I refered oracle error messages, in that action is try the operation later.

Tried again and getting the same error.

Also queried V$locked_object.
Didn't found the object_id of the package in V$locked_object.

Please guide me.


Regards
Salih KM
Re: ORA-04021 Error while recreating a Package [message #192007 is a reply to message #191435] Sat, 09 September 2006 14:23 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Try v$lock, alert log and look for trace files.

If You cannot find anything, bouncing the database might be an option, if this is the first time You see this problem.

Br
Kim
Re: ORA-04021 Error while recreating a Package [message #192010 is a reply to message #191435] Sat, 09 September 2006 14:25 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Please guide me.
Most likely, the package is held open by a different session.
Re: ORA-04021 Error while recreating a Package [message #192911 is a reply to message #192010] Thu, 14 September 2006 03:44 Go to previous message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Thanks it is solved.
I closed all the other sessions working and recompiled.

Previous Topic: ORA-00907: missing right parenthesis
Next Topic: Select data that is not in other table(Merged)
Goto Forum:
  


Current Time: Sun Dec 04 12:19:38 CST 2016

Total time taken to generate the page: 0.12421 seconds