ORACLE - Identifier les doublons

Identified les doublons pour ré-activer une contrainte:

select count(*),COLUMN_NAME from TABLE group by COLUMN_NAME having count(*) > 1;