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

#11

vijaysam wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#12

vijaysam wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#13

vijaysam wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

Re: can not insert a new row in a table, unique constraint violated. - 03-10-2008 , 11:15 AM

Re: can not insert a new row in a table, unique constraint violated. - 03-10-2008 , 11:15 AM

Re: can not insert a new row in a table, unique constraint violated. - 03-10-2008 , 11:15 AM