Home -> Usenet -> comp.databases.oracle -> Newbie problem figuring out parent/child problems

Newbie problem figuring out parent/child problems

From: general delivery <disc_at_iwaynet.net>
Date: 1996/01/28
Message-ID: <4egfea$5no_at_triglav.iwaynet.net>#1/1 






While creating test data for a new database, I spend frustrating hours 
trying to resolve the following messages:



Record ##: Rejected  Eror on table table_name
ORA-02291: integrity constraint (dbname.SYS_C########) violated - parent 
key not found



The test database I am created represents a business medical system.  The 
tables have quite a few foreign keys linking to other tables.  It takes 
me forever to manually review each foreign key to see which one I 
mis-typed.



I've looked in the Oracle manual set and learned that the SYS_C######## 
is defined in system tables.  I can see that the SYS_C######## is defined 
to the table_name but I can't find the magic system table that tells me 
which of the foreign keys SYS_C######## relates to.  If someone could 
help me out, it would help me through a very frustrating manual process.
Received on Sun Jan 28 1996 - 00:00:00 CET












Original text of this message