10 Replies Latest reply on Jun 18, 2013 2:49 AM by User764934-Oracle

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