Re: parent key not found error
Date: Sun, 2 Mar 2008 23:54:09 -0800 (PST)
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
Thanks a lot for helping me for the problem. Received on Mon Mar 03 2008 - 01:54:09 CST