Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!e10g2000prf.googlegroups.com!not-for-mail
From: Bhavin <bhavingoradiya@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: parent key not found error
Date: Sun, 2 Mar 2008 23:54:09 -0800 (PST)
Organization: http://groups.google.com
Lines: 27
Message-ID: <79ef6634-8e83-47a5-b2ed-e5e93d21de42@e10g2000prf.googlegroups.com>
References: <ee9d57d4-068b-4c88-8628-b2ad09375d22@e23g2000prf.googlegroups.com> 
 <1204272594.372807@bubbleator.drizzle.com>
NNTP-Posting-Host: 121.245.41.70
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1204530849 11921 127.0.0.1 (3 Mar 2008 07:54:09 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 3 Mar 2008 07:54:09 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e10g2000prf.googlegroups.com; posting-host=121.245.41.70; 
 posting-account=wrTuuwoAAACr9lwXIUICI1VdNPxnalya
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.1.4322),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:442036
X-Received-Date: Mon, 03 Mar 2008 02:54:09 EST (text.usenetserver.com)

On Feb 29, 1:09=A0pm, DA Morgan <damor...@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.o=
rgto see how this works.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor...@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.