Oracle-ORA-01502 Index rebuild error - ABC LEARN - 0 views
-
abclearn on 21 Feb 17Issue Description: When I tried to rebuild one of the indexes I received the following error: SQL> alter index I_WRI$_OPTSTAT_H_ST rebuild; alter index I_WRI$_OPTSTAT_H_ST rebuild * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST' or partition of such index is in unusable state.