Oracle 查询表对应的索引

佚名 6年前 (2019-04-24) 随笔 1570人围观抢沙发百度已收录

select col.table_owner "table_owner",
idx.table_name "table_name",
col.index_owner "index_owner",
idx.index_name "index_name",
uniqueness "uniqueness",
status,
column_name "column_name",
column_position
from dba_ind_columns col, dba_indexes idx
where col.index_name = idx.index_name
and col.table_name = idx.table_name
and col.table_owner = idx.table_owner
and col.table_owner = '&owner'
and col.table_name = '&table_name'
order by idx.table_type,
idx.table_name,
idx.index_name,
col.table_owner,
column_position;