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: ORA-00001: unique constraint violated

Re: ORA-00001: unique constraint violated

From: Michael <michael.lohmar_at_gmail.com>
Date: 15 Nov 2004 23:59:06 -0800
Message-ID: <1100591946.646586.252240@c13g2000cwb.googlegroups.com>

Hi,

>As you can't disable an index, you will need to drop it, if the
>constraint is not sensible.

In newer versions of Oracle an unique index is coded as an primary key constrain ... and of course you can disable it .... Greetings,
Michael Received on Tue Nov 16 2004 - 01:59:06 CST

Original text of this message

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