ORA-00001: unique constraint (...) violated is not necessarily a data conflict

Tag: I/O data 2014 Div CTI SP on EF C

In this case, after the table and index are rebuilt, the insert operation is normal.

Prompt importing table coupon_activity
Set feedback off
Set define off
Insert into coupon_activity (ID, activity_subject, begin_date, end_date, status, create_by, create_time, update_by, update_time, activity_code)
Values (1, 'goods online line', to_date ('01-08-2014 ', 'dd-mm-yyyy'), to_date ('10-09-2014 ', 'dd-mm-yyyy'), 0, 0, '26-August 14 06.44.13.000000 PM ', 0, '26-August 14 06.44.13.000000 PM ', 'ghwsx _ 001 ');


Prompt done.

ORA-00001: unique constraint (...) violated is not necessarily a data conflict