Re: can not insert a new row in a table, unique constraint violated.
Date: Mon, 10 Mar 2008 08:44:41 -0700 (PDT)
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.
robert Received on Mon Mar 10 2008 - 10:44:41 CDT