As everybody knows, Oracle creates unique index automatically when
primary key or foreign key constraints are created on table. They can
be checked by looking up DBA_INDEXES, ALL_INDEXES, etc., but I cannot
find any info that shows which index is associated with which
constraint, especially when index is created first and constraint is
added later with different names. Is there any way to find that out
without looking up DBA_IND_COLUMNS and DBA_CONS_COLUMNS and comparing
columns manually? Thank you in advance.
Received on Sat May 20 2000 - 00:00:00 CDT
