10 Replies Latest reply: Jun 17, 2013 9:49 PM by User764934-Oracle RSS

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

    User764934-Oracle

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