ORA-01502 when inserting record..
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:
Windows NT server
Click Here to Expand Forum to Full Width