Hi All,
I am having the above error code when inserting records into a table. The exact error code is:

ORA-01502: index'XXXX.pk' or partition of such index is nin unusable state
ORA-02063: preceding line from ****
ORA-06512: at *******', line 5
ORA-04088: error during execution of trigger '*****'

I found a few things unusual about the table. It seems as if there are duplicate values in the primary key column and I am thinking that has something to do with the problem. I have rebuilt the index and the problem is still occuring. Thanks for you help.


My system is as follows:
Oracle 8.1.6
Windows NT server