ORA-01502 when inserting record..
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.
Dee.
My system is as follows:
Oracle 8.1.6
Windows NT server
Re: ORA-01502 when inserting record..
Quote:
Originally posted by smallpin
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.
Dee.
My system is as follows:
Oracle 8.1.6
Windows NT server
your xxxxx.pk index is in unusable state. Check dba_indexes for unusable partitions