Re: HELP: Cannot (re-)enable constraint

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