Database - RAC/Scalability (MOSC)

MOSC Banner

How to fix ORA-00001: unique constraint (TBAADM.IDX_REF_TRN_TBL_HIST) violated while trying to inser

edited Jun 18, 2019 5:04AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center