Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02298 cannot enable name - parent keys not found
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