Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I can't able to compile Package

788239Jul 29 2010 — edited Jul 30 2010
Hi,

I can't able to compile package which contains 7241 lines, when tried to compile i got error has mentioned below

Note:- my server is (shared server)

CREATE OR REPLACE PACKAGE BODY spkg_hash
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object schemaname.spkg_hash.


After shutting down db and started i tried to compile it got compiled still i don't understand what happened in background


can anyone explain why this happening?

Edited by: user13051169 on Jul 30, 2010 2:52 AM

Edited by: user13051169 on Jul 30, 2010 2:55 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2010
Added on Jul 29 2010
7 comments
36,972 views