ORA-01452

ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


SQL> delete ZJDA.ZJ_T_YJFP where rowid not in(select min(rowid) from ZJDA.ZJ_T_YJFP group by C_JGBH,C_SJLX,N_SJHM,N_GS);

214789 rows deleted


SQL>
SQL> create UNIQUE index ZJDA.ZJ_T_YJFP_PK on ZJDA.ZJ_T_YJFP(       C_JGBH,
  2                                                                 C_SJLX,
  3                                                                 N_SJHM,
  4                                                                 N_GS) tablespace ZJDADATA ;

Index created

SQL>