How to fix ORA-00001: unique constraint (TBAADM.IDX_REF_TRN_TBL_HIST) violated while trying to inser
SQL> INSERT INTO TBAADM.REF_TRN_TBL_HIST SELECT * FROM TBAADM.REF_TRN_TBL where TRAN_DATE='14-05-2019';
INSERT INTO TBAADM.REF_TRN_TBL_HIST SELECT * FROM TBAADM.REF_TRN_TBL where TRAN_DATE='14-05-2019'
*
ERROR at line 1:
ORA-00001: unique constraint (TBAADM.IDX_REF_TRN_TBL_HIST) violated