Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Does a lock on a parent table locks up alter table disable constraint?
Hi all:
I am encountering a following situation:
The first developer's command is stuck until the second one releases the
lock. I have seen it several times today
Why does this happen? I would understand that an ENABLE command would be
affected by that, but why would
a DISABLE command be affected?
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 19 2006 - 17:20:42 CDT
![]() |
![]() |