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!

Enable table lock.

Bahram OrujovJun 20 2018 — edited Jun 22 2018

Hi. I wont to enable table lock. I try this query/

ALTER TABLE owner.table_name ENABLE TABLE LOCK;

But I get

ALTER TABLE owner.table_name ENABLE TABLE LOCK

Error report -

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

00054. 00000 -  "resource busy and acquire with NOWAIT specified or timeout expired"

*Cause:    Interested resource is busy.

*Action:   Retry if necessary or increase timeout.

But There is not any other DML or DDL on this table.

The question is: How can I enable lock table?

This post has been answered by Bahram Orujov on Jun 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2018
Added on Jun 20 2018
16 comments
3,827 views