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

On 10 Mrz., 16:38, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
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

On 10 Mrz., 16:38, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
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

On 10 Mrz., 16:38, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
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

On 10 Mrz., 16:38, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
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

Comments embedded.
On Mar 10, 10:38*am, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
And you have at the very least a UNIQUE index on that table.

As I said, it's a UNIQUE index.

You've tried to insert a 'key' value which already exists in the
table. You cannot do that with a unique index in place. This is
covered in the Concepts Guide, which you should be reading.


David Fitzjarrell

Comments embedded.
On Mar 10, 10:38*am, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
And you have at the very least a UNIQUE index on that table.

As I said, it's a UNIQUE index.

You've tried to insert a 'key' value which already exists in the
table. You cannot do that with a unique index in place. This is
covered in the Concepts Guide, which you should be reading.


David Fitzjarrell

Comments embedded.
On Mar 10, 10:38*am, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
And you have at the very least a UNIQUE index on that table.

As I said, it's a UNIQUE index.

You've tried to insert a 'key' value which already exists in the
table. You cannot do that with a unique index in place. This is
covered in the Concepts Guide, which you should be reading.


David Fitzjarrell

Comments embedded.
On Mar 10, 10:38*am, vijaysam <vsamb... (AT) gmail (DOT) com> wrote:
And you have at the very least a UNIQUE index on that table.

As I said, it's a UNIQUE index.

You've tried to insert a 'key' value which already exists in the
table. You cannot do that with a unique index in place. This is
covered in the Concepts Guide, which you should be reading.


David Fitzjarrell

vijaysam wrote:
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