[thelist] oracle related database error

Jeremy Weiss eccentric.one at gmail.com
Mon Aug 30 08:20:19 CDT 2010


I use a program called Navicat in order to manage my databases. Using
it, I can see which tables are related to the table I'm viewing, and
by what fields. I'm sure other programs have a similar feature,


On Mon, Aug 30, 2010 at 7:12 AM, Daniel Kessler <danielk at umd.edu> wrote:
> 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
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list