DIPTENDU HUI

• Jan 28th, 2006

 

For Indexes you can use :

DBA_INDEXES

ALL_INDEXES

USER_INDEXES

For Constraint you can use :

DBA_CONSTRAINTS

ALL_CONSTRAINTS

USER_CONSTRAINTS

For index upon which table and which column you can query on:

DBA_CONS_COLUMNS

ALL_CONS_COLUMNS

USER_CONS_COLUMNS