Re: HELP: Cannot (re-)enable constraint

Thanks for the tip.

It cleared the problem.

"Christophe Roux" <roux.c_at_ibm.net> wrote:

>We had the same problem. This is a very strange Oracle bug (I don't have
>the Oracle bug number here).
>To be able to re-enable the FK, just do "analyze table_name delete
>statistics " on the parent and the child table.
>This may sound very strange but this workaroud was given by our Oracle
>Support and it worked very well.

>Tim Auckland <auckland_at_probita.com> wrote in article
><mortDwLpBz.HAy_at_netcom.com>...
>> We're running Oracle 7.1.4 on HPUX 10.10
>>
>> During an import process, we disable foreign key constraints, and
>> re-enable them after the import has finished.
>>
>> We can re-enable some of the constraints without a problem, but some,
>> even referring to the same indexed table column, fail with
>>
>> ORA-02298 ... - parent keys not found.
>>
>> The parent keys definitely exist.
>>
>> Any help with this problem would be greatly appreciated.
>>
>> Tim Auckland.
>>
>>
Received on Mon Aug 26 1996 - 00:00:00 CEST