Re: disabling foreign keys
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 17 Feb 2011 09:28:17 -0800
Message-ID: <AANLkTi=2673MKwSCwA_gmv5g5hEMVUZrx5Sja+Mfi5_r_at_mail.gmail.com>
Generally I think most who desire this behavior use "rely disable novalidate" for their FKs.
http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/constra.htm#i1006284
Date: Thu, 17 Feb 2011 09:28:17 -0800
Message-ID: <AANLkTi=2673MKwSCwA_gmv5g5hEMVUZrx5Sja+Mfi5_r_at_mail.gmail.com>
Generally I think most who desire this behavior use "rely disable novalidate" for their FKs.
http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/constra.htm#i1006284
On Thu, Feb 17, 2011 at 12:28 AM, Timur Akhmadeev
<Akhmadeev_at_netcracker.com> wrote:
> But you can make CBO to rely on the constraint even if it is disabled:
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 17 2011 - 11:28:17 CST