Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: REFENTIAL

RE: REFENTIAL

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 15 Oct 2004 09:19:15 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF49@usahm018.exmi01.exch.eds.com>


I do not know where the link was to since I got a 404 when I tried to follow it, but the dictionary view dba_constraints view can be used to list all FK's that reference a PK or UK constraint. This sound like what Seema wants.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stephane Faroult Sent: Friday, October 15, 2004 8:20 AM
To: oracle-l_at_freelists.org; 'Seema Singh' Subject: REFENTIAL  

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/toc.htm[ 1]
Regards,

Stephane Faroult

RoughSea Ltd
http://www.roughsea.com

On Fri, 15 Oct 2004 08:04 , 'Seema Singh' <oracledbam_at_hotmail.com> sent:

Hi,
Which view will tell how many tables are refering that columns? Let us consider one table tab1 with pk ID,I wanted to know which others tables are refeing ID as FK/reference key. thanks
-Seema

http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 15 2004 - 08:15:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US