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:
1 | 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