oracle 查看表的索引信息

1.select * from user_indexes where table_name='PAMSODT0P02'

2.select * from user_ind_columns  where index_name='IDX_PAMSODT0P02_LOCATOR'