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

vijaysam wrote:
> Hi ,
>
> 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?
>
> regards
>
> Vijay

For help post your version number (3+ decimal places) and the actual error message not your interpretation of it.

Robert and Fitzjarrell undoubtedly correct but if you can't sort it out perhaps this will help:

SELECT index_name, index_type
FROM all_indexes
WHERE table_name = 'DCTCONRB';

SELECT constraint_name, constraint_type
FROM all_constraints
WHERE table_name = 'DCTCONRB';

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org