Re: disabling foreign keys

From: Clay Colburn <clay.colburn_at_gmail.com>
Date: Thu, 17 Feb 2011 17:13:35 -0800
Message-ID: <AANLkTik=ZZRuXniBEa0o26UVr7WdXK6fMiyHwvEjhz7K_at_mail.gmail.com>

This is great info, thanks so much guys!

On Thu, Feb 17, 2011 at 9:28 AM, Greg Rahn <greg_at_structureddata.org> 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_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-l

Received on Thu Feb 17 2011 - 19:13:35 CST