Re: ORA-00001: unique constraint (%s.%s) violated

Dereck L. Dietz wrote:
> Oracle 10g 10.2.0.3.0
> Windows 2003 Server
>
> ERROR at line 1:
>
> ORA-00001: unique constraint (%s.%s) violated
>
> I'm getting the above error despite the fact that the error line is pointing
> to a BULK FETCH into a nested table and also that the table being loaded has
> no constraints defined on it whatsoever.
>
> This very same code ran without problem last month (monthly run) and the
> last time the code has been changed at all has been back in January 2008.
>
> With the %s.%s in the description I'm wondering if it's a false error and
> something else is going on. I can make no sense why I'm getting a
> constraint violation where there is no constraint.
>
> Has anybody else run into anything like this?

I've never seen it before but I would suggest starting in DBA constraints looking for any constraints on the table and any constraints referencing the table.

What bothers me about what you've written is that it is impossible to violate a constraint with a BULK FETCH so you seem to be pointing your finger in the wrong direction. Find the INSERT or UPDATE statement that is triggering the problem and post it.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org