Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Table Locks Adding Foreign Keys
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-lReceived on Wed Oct 06 2004 - 11:44:34 CDT
![]() |
![]() |