ORA-00001: unique constraint violated error
Hi,
Oracle9.2
Table T has four columns A,B,C,D all are not null. Also, unique constraint is defined on column A & B
but, one of the insert statement got failed with the below error.
Getting DB Error: ORA-00001: unique constraint violated error on inserting the value.
It means already record is existing in the table.
As, thousands of records are getting inserted online in the table at a time, so could not able to trace which record is being inserted.
So, how to find that record in the table which is already existing due to which above unique constraint violation error is raised ?
With Regards