RE: table, index, associated constraint

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 3 Aug 2004 18:06:02 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNMEMCCGAA.lex.de.haan@naturaljoin.nl>

Hi Barbara,
this is "fixed" years ago (I entered this once as an enhancement request) -- which Oracle release are we talking? check out the ALL_CONSTRAINTS view definition ...

Kind regards,
Lex.

visit my website at http://www.naturaljoin.nl <http://www.naturaljoin.nl>

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Barbara Baker Sent: Tuesday, August 03, 2004 16:52
To: oracle-l_at_freelists.org
Subject: qry: table, index, associated constraint

Does anyone have a query they are willing to share that displays the table, index, and associated constraint?

I found the following query on Jonathan Lewis' site that gives me 2 out of 3 (index and cons), but I can't see a way to grab the associated table.

Thanks for any help!
Barb

http://www.jlcomp.demon.co.uk/faq/constraints_and_indexes.html The connection between constraints and the indexes which are used to check these constraints for the current user can be described by this query:

select --+ rule

            o.owner as index_owner


            , o.object_name as index_name

            , n.name as constraint_name

        from    sys.cdef$ c


            , dba_objects o

            , sys.con$ n

        where c.enabled = o.object_id
        and c.con# = n.con#
        and n.owner# = uid

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 11:01:56 CDT