RSS

ORA – 00001

12 Feb

ORA – 00001

Unique Constraint violated.

Cause:     When u are trying to insert a value into a row, duplicates wont be allow.

Either don’t enter duplicates or follow below process

  1. Drop the Unique key constraint
  2. Change the constraint to allow duplicates
  3. Modify your Sql statement (So that a duplicate value is not created)

NOTE: Mostly, we get these alert while doing the import.

 
Leave a comment

Posted by on February 12, 2013 in Ora Errors

 

Tags:

Leave a comment