Re: Table Locks Adding Foreign Keys

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 7 Oct 2004 02:09:25 +0100 (BST)
Message-ID: <20041007010925.47308.qmail@web86908.mail.ukl.yahoo.com>

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_at_aurora.org 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_at_yahoo.com

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

Received on Wed Oct 06 2004 - 20:13:34 CDT