Re: parent key not found error

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 at www.psoug.org to see how this works.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org