Re: unique constraint (%s.%s) violated

So you are telling us, it's Oracle's word against yours? :-) I would bet Oracle is right in this case, and that you are inserting duplicate rows and/or a row that already exists for the unique key constraint.

On Thu, Jul 23, 2009 at 10:12 PM, Krishan Gupta <krishan.gupta_at_etcc.com>wrote:

> Hi list,
>
>
>
> Today while trying to insert a row into a table (have 500000 rows approx) I
> got the following error :-
>
>
>
> ERROR at line 1:
>
> ORA-00001: unique constraint (%s.%s) violated
>
>
>
> I am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
> 64bit.
>
>
>
> I am not violating any constraint while inserting this row.
>
>
>
> Any idea about why I am getting this and How to resolve this error ?
>
>
>
> Thanks in Advance
>
> Krishan
>
>
>

-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

--
http://www.freelists.org/webpage/oracle-l