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

Home -> Community -> Mailing Lists -> Oracle-L -> Table Locks Adding Foreign Keys

Table Locks Adding Foreign Keys

From: <todd.sheetz_at_aurora.org>
Date: Wed, 6 Oct 2004 11:48:54 -0500
Message-ID: <OF9E4B5070.A57470F4-ON86256F25.005B71FF-86256F25.005C5EF6@aurora.org>


This probably has a very easy answer, but I can't seem to find it. I have a 260 million row table that I need to add a foreign key constraint to that references another table with 30 million rows. Will adding the constraint cause any locking during the time the constraint is being validated? This is a vendor application and they are telling us that we can run this while users are in the system. I have some doubt about whether this would place at least a share lock on the table. Any information is appreciated.

Thanks

Todd

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 06 2004 - 11:44:34 CDT

Original text of this message

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