Laurent Hinoul

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - John F. Woods

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:

  • delete the data from the table where the index is part of
  • rebuild the index with the following SQL command:
  • enjoy the fix

Leave a Reply