Skip to main content

Home/ Diigo Community/ Group items matching "oracledba" in title, tags, annotations or url

Group items matching
in title, tags, annotations or url

Sort By: Relevance | Date Filter: All | Bookmarks | Topics Simple Middle
abclearn

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.
1 - 1 of 1
Showing 20▼ items per page