I am using below to compare 2 indexes, but is there any way to compare two views in oracle to see the result like identical, not Exists or different by structure perspective ?
select decode
(
sum(decode(column_name_1, column_name_2, 0, 1))
, 0
, 'Identical'
, null
, 'Not exist'
, 'Different'
) index_status
from (
select column_position
, max(decode(index_owner, 'USER1' , column_name)) column_name_1
, max(decode(index_owner, 'USER2', column_name)) column_name_2
from all_ind_columns
where table_name = 'TBL_A'
group
by column_position
)