Oracle Forms (MOSC)

MOSC Banner

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

edited Dec 2, 2012 7:34PM in Oracle Forms (MOSC) 12 commentsAnswered ✓
I received the "ORA-01502: index or partition of such index is in un-usable state" error from one of our Oracle forms, and the problem was caused by using SQL Loader w/ the "DIRECT" load option in our production database.  As a result of that, the system won't allow me to insert or delete rows from the problematic table.

When I tried to delete the duplicate rows from the table, I received the "ORA-01502: index or partition of such index is in un-usable state" error message;

When I tried to rebuild the index by using the following command:

ALTER INDEX index_name REBUILD

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center