Skip to Main Content

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!

how to release a ddl lock?

ys123Oct 25 2012 — edited Oct 26 2012
Hi dear all,
A compiling session held a ddl lock on some db objects . After killed the session (using PL/SQL Developer GUI), the lock did not got released and can be found in dba_ddl_locks . Did I miss something ? Many thanks!

Edited by: user6351589 on 2012-10-25 下午7:46
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2012
Added on Oct 25 2012
5 comments
2,573 views