[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
http://sph.umd.edu
More information about the thelist
mailing list