This discussion is archived
10 Replies Latest reply: Jun 17, 2013 7:49 PM by user764934 RSS

Error ORA-00001: unique constraint (ssr_visit.PK) violated

user764934 Newbie
Currently Being Moderated

I have suddenly started getting this error on one of my table  ssr_visit


I have visit_id as primary key bind by sequence.  I have tried following but no use...


1. Drop constraint and insert record manually.

2. tried making index non-unique but could not succeed as it gave error


PLS HELP!!  I am bit new to database. Answer with steps in layman's tern would be appreciated!!