I receive the following pop-up error message when I perform a select * or column on a particular table, where the column is a member of the unique index.
"Duplicate value found..."
OR
"A Constraint named 'Constraint1' already belongs to this DataTable"
The history is that I recently created a unique index on the table without validate, meaning there are currently records in the table that violate the unique constraint.
To create the unique index I executed the following two commands:
create index myindex_uk on tblWidget (colA, colB);
alter table tblWidget add constraint myindex_uk unique (colA, colB) enable novalidate;
Now, I cannot select from the table using OraDeveloper. However, I can using sqlplus.
It looks like OraDeveloper is creating a datatable that matches the one in the database that includes the unique constraint. It would be nice if that feature could be sometimes disabled somehow...