Skip to main content

/ Diigo Community/ Group items tagged oracledba

Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

Oracle-ORA-01502 Index rebuild error - ABC LEARN - 0 views

www.abclearn.com/...ora-01502

oracledba oracle troubleshooting

shared by abclearn on 21 Feb 17 - No Cached

abclearn on 21 Feb 17

Issue 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.

<div class="cArrow"> </div><div class="cContentInner">Issue 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.</div>

...

Cancel

1 - 1 of 1

Showing 20▼ items per page

Related searches