duplicate rows in an active primary key
Hi there,
We have a table which has a VALID and ACTIVE PK on a single column and it contains duplicate keys.
This happens on a Oracle Database 11g Enterprise Edition Release 11.1.0.7.0.
If you select the table using the index then only one row returns.
If you select the table using the /*+ NOINDEX */ hint then it returns the duplicate keys.
If you DISABLE/ENABLE the constraint or DROP/CREATE/REBUILD the index, you get the an error (as it should be) to state that there are duplicates.
We cannot think of any instance that the PK would have been UNUSABLE. Even if it would have been the case, ORACLE would have thrown an exception,
since we /*+ HINT */ the index (exception "index not usable")
Has anyone encountered this behavior?
This is really shocking since this is a basic database functionality...
Cheers,
Alex
Edited by: BRZ-DWH Steuer on Feb 22, 2013 12:16 AM