How to find the index name of an oracle table?

Question

477 views04/10/2022Oracle Database

0

Ezana886 03/10/2022 0 Comments

How to find the index name and index type of an oracle table?

Write your answer.

score 0 · Answer 1 · 2022-10-04T13:58:49+00:00

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.