SQL & PL/SQL

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!

Lock on object....

abhishek476Mar 31 2010 — edited Mar 31 2010

Hi All,

I'm trying to make few changes in one of the packages, and then compile but i'm not able to get a lock on the objects as its being used by a lot of other processes, and hence not able to compile.

We canot afford to kill the session, as this pkg is a crucial component and hence killing even one session might cause problem.

Can anybody please suggest an alternate.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2010

Added on Mar 31 2010

4 comments

2,362 views