Re: ORA-02298 cannot enable name - parent keys not found

From: <dgallardo_at_my-deja.com>
Date: Fri, 01 Oct 1999 14:24:45 GMT
Message-ID: <7t2g6v$vno$1@nnrp1.deja.com>

You can set the field that references the foreign key to NULL for every record that is orphaned. You should then be able to enable the constraint.

In article <7t1tar$hku_at_romeo.logica.co.uk>, "Edwin Hartog" <hartoge_at_logica.com> wrote:
> An ALTER TABLE ENABLE CONSTRAINT command failed because the table has
> orphaned child records.
>
> In the Server messages the following action needs to be done:
>
> Action: Make sure that the table has no orphaned child records before
> issuing an ALTER TABLE ENABLE CONSTRAINT command.
>
> Any Oracle DBA who has experience with this server message and can
tell me
> how to solve this problem ??
>
> TIA
> ----
>
> Edwin H. Hartog
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 09:24:45 CDT