Check possible duplicities in indexed columns


select C.TABLE_NAME, C.COLUMN_NAME, C.COLUMN_POSITION, COUNT(*) AS POCET
from all_ind_columns c
where c.table_owner = 'RMS' AND C.TABLE_NAME LIKE '.....your_table_mask....%'
HAVING COUNT(*)>1
GROUP BY C.TABLE_NAME, C.COLUMN_NAME, C.COLUMN_POSITION

Leave a Reply

Your email address will not be published. Required fields are marked *