Re: Child records with no parent in 10.2.0.3

From: <fitzjarrell_at_cox.net>
Date: Thu, 04 Oct 2007 07:58:18 -0700
Message-ID: <1191509898.196271.97200@50g2000hsm.googlegroups.com>

On Oct 4, 8:57 am, "Richard Foote" <richard.fo..._at_nospam.bigpond.com> wrote (among other things):
>
> However, putting a FK in disable validate is questionable to say the least?
>

I agree entirely, however it is allowed by Oracle and, as such, one can create an undesirable situation of a valid FK constraint on a table containing orphaned data. Of course as Howard explained it's a limited-use option (designed for DW reloads, apparently).

I simply wasn't expecting the outcome I received using 10.2.0.3.

We live, we learn.

David Fitzjarrell Received on Thu Oct 04 2007 - 09:58:18 CDT