Re: Newbie Question: ORA-02291

From: Joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: Fri, 5 Mar 1999 12:21:48 +0100
Message-ID: <7boeme$g1k$1@mailgate.ikea.com>

You have two tables where one is the parent.

Eg there can be no records in the child that doesn't have a corresponding row in the parent table.

Do the insert in the parent table first.

Regards
/Joachim

mariam_tariq_at_csx.com wrote in message <7bn2ef$8i8$1_at_nnrp1.dejanews.com>...
>Can someone explain the following msg. My reference books don't
>say much.
>
>ORA-02291: integrity constraint (PRM_OWN.FK_LCTNGRPMBR_LOCATIONGRP)
violated -
>parent key not found
>
>
>Thanks,
>Mariam
>
>mariam_tariq_at_csx.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 05 1999 - 05:21:48 CST