[thelist] oracle related database error

Luther, Ron Ron.Luther at hp.com
Mon Aug 30 08:20:27 CDT 2010

Daniel Kessler asked:

>>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.

Hi Daniel,

Not something I play with much, but Oracle has a plethora of 'administrative' tables.  Take a look at the USER_CONSTRAINTS table.

My guess is you want something like "Select * from USER_CONSTRAINTS where TABLE_NAME = 'People';"  

That should get you the names of all the constraints referencing your table.  From there your schema naming convention should let you figure out which table name goes with which constraint name.

Good Luck,

More information about the thelist mailing list