Re: Table Locks Adding Foreign Keys

Add as "novalidate"  (which is a brief lock)
Then "validate" (which does the scanning part but does not lock the table)

hth
connor

 --- todd.sheetz@xxxxxxxxxx wrote: 
> 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
>  

=====
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, 
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------


        
        
                
___________________________________________________________ALL-NEW Yahoo! 
Messenger - all new features - even more fun!  http://uk.messenger.yahoo.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: