title: Unique constraint violation during insert: why? (Oracle)
body: <p>I'm trying to create a new row in a table.  There are two constraints on the table -- one is on the key field (DB_ID), the other constrains a value to be one of several the the field ENV.  When I do an insert, I do not include the key field as one of the fields I'm trying to insert, yet I'm getting this error:</p>
  
  <pre><code>unique constraint (N390.PK_DB_ID) violated
  </code></pre>
  
  <p>Here's the SQL that causes the error:</p>
  
  <pre><code>insert into cmdb_db 
     (narrative_name, db_name, db_type, schema, node, env, server_id, state, path) 
  values 
     ('Test Database', 'DB', 'TYPE', 'SCH', '', 'SB01', 381, 'TEST', '')
  </code></pre>
  
  <p>The only thing I've been able to turn up is the possibility that Oracle might be trying to assign an already in-use DB_ID if rows were inserted manually.  The data in this database was somehow restored/moved from a production database, but I don't have the details as to how that was done.</p>
  
  <p>Any thoughts?</p>