10 Replies Latest reply: Jun 17, 2013 9:49 PM by user764934 RSS

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


      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!!