Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Does a lock on a parent table locks up alter table disable constraint?

Does a lock on a parent table locks up alter table disable constraint?

From: <genegurevich_at_discoverfinancial.com>
Date: Fri, 19 May 2006 17:20:42 -0500
Message-ID: <OF31AF4F12.7D4FF068-ON86257173.007A7E2D-86257173.007ABD8B@discoverfinancial.com>


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-l
Received on Fri May 19 2006 - 17:20:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US