How to find the index name and index type of an oracle table?
Anonymous Answered question 04/10/2022
Below is the script to find the index name and type of an oracle table:
select index_name,index_type from dba_indexes where table_name='ACTB_HISTORY'
Where ACTB_HISTORY is the table name.
meda Changed status to publish 04/10/2022