Re: Parent not found error when child table contains nulls

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/12/26
Message-ID: <Pine.SUN.3.91.951226125532.28190B-100000_at_seatimes>#1/1

There was a bug in 7.0.16 and 7.1.4 (if I remember correctly) that would not allow a FK constraint to be enabled (or created) if there were analyze statistics on the tables in question. Never did figure out if the statistics were on the partent table or the child table. Removing the statistics allowed the FK to be created just fine.

On 20 Dec 1995, glc wrote:

> Trying to create a foreign key constraint gets the ORA-2294, Parent keys not found
> error when the column in the child table contains nulls. I know I can remove the
> data, create the constraint & put the data back, but I think there may be an easier
> work-around. Anybody know one? (the child column is indexed.)
> Thanks.
>
>
>

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue Dec 26 1995 - 00:00:00 CET