[thelist] oracle related database error

Daniel Kessler danielk at umd.edu
Mon Aug 30 07:12:47 CDT 2010

I'm working in Oracle.  I have a table of People with unique IDs.  I  
want to delete one of the people, but one of my other related tables  
has a relationship with that person, so I can't delete them, receiving  
the error "integrity constraint (DPCH.SYS_C0096833) violated - child  
record found".

I understand the problem.  However, how do I determine which related  
table includes the person, so that I can go and delete the information  
for that related table?  I have about 100 tables.


Daniel Kessler

University of Maryland College Park
School of Public Health
2242A SPH Building
College Park, MD  20742-2611
Phone: 301-405-2545

More information about the thelist mailing list