1 Reply Latest reply: Nov 14, 2012 12:56 PM by John Spencer RSS

    SQL Error: ORA-00001: unique constraint (Schema1.UN_PREF) violated

    970021
      I'm getting the SQL Error: ORA-00001: unique constraint (Schema1.UN_PREF) violated error message when I run an insert statement.
      When I run
      select * from all_constraints where constraint_name = 'UN_PREF';  
      I don't see any records. I am logged in as Schema1. What could be the problem?

      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

      Edited by: 967018 on Nov 14, 2012 10:40 AM