UNIQUE CONSTRAINT ERROR
From: Paul <dontemail_at_yahoo.com>
Date: Thu, 25 May 2006 08:46:28 -0400
Message-ID: <IGhdg.697$vX5.309_at_fe12.lga>
Received on Thu May 25 2006 - 14:46:28 CEST
Date: Thu, 25 May 2006 08:46:28 -0400
Message-ID: <IGhdg.697$vX5.309_at_fe12.lga>
I have some PL/SQL code that has been running for several
years and just started giving me problems. It inserts a record from one
database to another going across a dblink.
It recently started giving me this error:
ORA-00001: unique constraint (SIEBEL.S_EVT_ACT_M9)
violated
The problem is that SIEBEL.S_EVT_ACT_M9 is an index, but it is
NOT a unique index.
When I had the problem a week ago I suspected a corrupt index,
so I dropped and recreated the index. This fixed the problem.
However the problem came back this week.
So now I need to get to the root cause and find out what is
happening to this index.
Any help would be appreciated.
Thank you.
--
Paul LaBarbera
Oracle DBA Manager, AT&T, Morristown, NJ
--
Paul LaBarbera
Oracle DBA Manager, AT&T, Morristown, NJ