See the FAQ listed below.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Dale Edgar wrote in message <3ba856d4.411831_at_news.btclick.com>...
>Hi All
>
>Does anybody know how to relate the name of the primary key in
>USER/DBA_CONSTRAINTS to the index that backs it up. The key name and
>the index name are not necessarily always the same. For example if one
>has the following DDL (in 8.1.6):
>
Received on Wed Sep 19 2001 - 04:58:26 CDT
