Re: ORA-00001: unique constraint (%s.%s) violated - SOLVED
Date: Fri, 6 Jun 2008 17:59:25 -0400
Message-ID: <1ri2k.1085$L_.657@flpi150.ffdc.sbc.com>
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1212690770.775152_at_bubbleator.drizzle.com...
> Dereck L. Dietz wrote:
>> Problem solved. The source table which was used as the source for the
>> load was structurally modified without anybody being notified of the
>> changes.
>>
>> The error being displayed was a "false" error and had to do with the code
>> had been expecting column sizes of 11 and 12 but was receiving columns
>> sized 25 and 20 instead.
>
> A table definition was modified without anybody being notified?
>
> I'd say you've got a problem a lot bigger than anything that an
> exception handler can catch.
> --
> 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
Yes I strongly suggested better change management be implemented. Received on Fri Jun 06 2008 - 16:59:25 CDT