Re: RE: references trace

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 3 Mar 2011 17:07:33 +0000
Message-ID: <AANLkTimAoy0E7KdPKg7=13seLDkoF7op1dByKSixNmmi_at_mail.gmail.com>

Just adding to Mark, I wouldn't rely on the constraint name as your postgres eg seems to do. None of this deals with apps that 'enforce' relationships in the app.

On 3 Mar 2011 16:05, "Bobak, Mark" <Mark.Bobak_at_proquest.com> wrote:

You should take a look at DBA_CONSTRAINTS and DBA_CONS_COLUMNS.

Look for constraints with CONSTRAINT_TYPE='R'.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.or...

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 03 2011 - 11:07:33 CST