Re: parent key not found error

From: Bhavin <bhavingoradiya_at_gmail.com>
Date: Sun, 2 Mar 2008 23:54:09 -0800 (PST)
Message-ID: <79ef6634-8e83-47a5-b2ed-e5e93d21de42@e10g2000prf.googlegroups.com>


On Feb 29, 1:09 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Bhavin wrote:
> > Hello Group,
>
> > I m Bhavin Goradiya learning oracle.
> > when i importing data from backup it gives error "parent key not
> > found". Please help me. i'm very confused regarding this error.
>
> You are inserting into a table where column values are constrained
> by a foreign key (referential) constraint.
>
> You must have the value in the parent table before putting it into
> the child so it can look it up.
>
> Look at the REFERENTIAL CONSTRAINT demos in Morgan's Library atwww.psoug.orgto see how this works.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Dear Sir,

Thanks a lot for helping me for the problem. Received on Mon Mar 03 2008 - 01:54:09 CST

Original text of this message