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

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

RE: Table Locks Adding Foreign Keys

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Wed, 6 Oct 2004 13:01:44 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA314E272D9@EXCHANGE>


No, it will not lock anything if you specify "ENABLE NOVALIDATE".

--
Mladen Gogala
A & E TV Network
Ext. 1216



> -----Original Message-----
> From: todd.sheetz_at_aurora.org [mailto:todd.sheetz_at_aurora.org]
> Sent: Wednesday, October 06, 2004 12:49 PM
> To: oracle-l_at_freelists.org
> Subject: Table Locks Adding Foreign Keys
>
> whether this would place at least a share lock on the table.
> Any information is appreciated.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 06 2004 - 11:57:24 CDT

Original text of this message

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