Re: can not insert a new row in a table, unique constraint violated.
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 10 Mar 2008 08:44:41 -0700 (PDT)
Message-ID: <101c5005-d808-4122-a6ef-74bc59ec0ff5@x41g2000hsb.googlegroups.com>
Date: Mon, 10 Mar 2008 08:44:41 -0700 (PDT)
Message-ID: <101c5005-d808-4122-a6ef-74bc59ec0ff5@x41g2000hsb.googlegroups.com>
On 10 Mrz., 16:38, vijaysam <vsamb..._at_gmail.com> 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.
Cheers
robert Received on Mon Mar 10 2008 - 10:44:41 CDT