Re: disabling foreign keys

  • From: Clay Colburn <clay.colburn@xxxxxxxxx>
  • To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 17 Feb 2011 17:13:35 -0800

This is great info, thanks so much guys!


On Thu, Feb 17, 2011 at 9:28 AM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:

> 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@xxxxxxxxxxxxxx> wrote:
> > But you can make CBO to rely on the constraint even if it is disabled:
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>

Other related posts: