Re: can not insert a new row in a table, unique constraint violated.

From: Robert Klemme <>
Date: Mon, 10 Mar 2008 08:44:41 -0700 (PDT)
Message-ID: <>

On 10 Mrz., 16:38, vijaysam <> wrote:
> I can not insert a row in a table called duct_connectivity.
> when I try to it says.. unique constraint prd.dctconrb `violated.
> not I found out there was no conatraint by this name on the table.
> but there was a index on the table by this name.
> what is happening here.. what is the solution?

Please post DDL for the table including all constraints, your SQL that fails and probably Oracle version.

As first wild guess: you have a unique index on that table and try to insert a duplicate value.


robert Received on Mon Mar 10 2008 - 10:44:41 CDT

Original text of this message