www.allfree-stuff.com


Monday, May 15, 2017

How to fix ORA-01502 index or partition of such index is in usable state




If you get the error How to fix ORA-01502: index or partition of such index is in usable state in Oracle. It is possible that an index is broken from a table.


To fix this error, you can do the following:

rebuild the index with the following SQL command:


ALTER INDEX your_index_name REBUILD;



No comments: