We are seeing an Oracle Index error(no ORA number only text is returned) of
Index <index name> is defined identically to constraint <constraint name>
Investigating this with Oracle SQL Developer and Toad (so we know that this is not a bug in our development platform software), the primary key constraint has an index name say PK_TABLENAME. When we look at the list of indexes, there is an identical index called PK_TABLENAME. This is happening on many of the tables in the schema, but not all. I am guessing that the issue is not that there are two duplicate indexes, but that Oracle thinks there are two indexes because the constraints table and the indexes table both have entries. Anyone seen this issue and does anyone have a solution, short of exporting the tables, recreating them without keys, then applying the primary key and all other indexes after.