Re: foreign key constraint and the index_name in user_constraint table

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 30 Sep 2004 20:53:09 -0400
Message-Id: <415CAA75.000001.01036@DAZA-MGEJCA5J7T>

check dba_constraints, maybe you are not the owner, and if you don't find, look at dba_objects, remember upper case.  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 

From: nn20002_at_netscape.net
Date: 09/30/04 19:53:04
To: oracle-l_at_freelists.org
Subject: foreign key constraint and the index_name in user_constraint table  

Hi,
Could you please help me in this issue.
I have a foreign key on a child table referencing the primary key of the parent table. I have created the index on the foreign key on the child table  Now, how do I know that the foreign key constraint is using the index or not.
I tried to see the index name from user_constarints table, but it always shows empty. When index_name is empty, what does it mean, even though I have it.
Thanks
nagu    

---

Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register  

Netscape. Just the Net You Need.  

New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp
--

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

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 30 2004 - 19:48:30 CDT