Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question: ORA-02291

Re: Newbie Question: ORA-02291

From: Van Messner <vmessner_at_netaxis.com>
Date: Thu, 4 Mar 1999 19:31:04 -0500
Message-ID: <cGFD2.806$xM2.785@news6.ispnews.com>


Looks like have table A with a column which is foreign-keyed to another table B. Any value you try to put into the column in table A must already exist in table B. It doesn't exist in B so you're getting an error.

Van

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 Thu Mar 04 1999 - 18:31:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US