Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNIQUE CONSTRAINT ERROR

Re: UNIQUE CONSTRAINT ERROR

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 25 May 2006 16:16:35 +0200
Message-ID: <d1fb72hqmj9u1hoa626e8vgsv1mtkojk6i@4ax.com> 





On Thu, 25 May 2006 08:44:56 -0400, "Paul" <dontemail_at_yahoo.com>
wrote:



>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.




Unique constraints can be enforced by non-unique indexes.


--
Sybrand Bakker, Senior Oracle DBA


Received on Thu May 25 2006 - 09:16:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US