This discussion is archived
1 Reply Latest reply: Nov 14, 2012 10:56 AM by John Spencer RSS

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

970021 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points