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

H

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:
    ALTER INDEX <indexname> REBUILD;
  • enjoy the fix

Add comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Tag Cloud

Categories

%d bloggers like this: