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!

how can I enable a constraint even ORA-00054

ManPakHongDaveSep 2 2013 — edited Sep 3 2013

Dear,

ALTER TABLE CLC_TRM_DTS_ATRBT

MODIFY CONSTRAINT CLC_TRM_DTS_ATRBT_02_FK ENABLE;

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

Any way to enable the constraint even any uncommited session or locked?

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2013
Added on Sep 2 2013
7 comments
2,640 views