Support Article

DatabaseException: partition of such index is in unusable state



Database exceptions were seen in log files and poor performance observed in system.

Error Messages

Error in commit() ORA-01502: index 'PC_ASSIGN_WORKLIST_PK' or partition of such index is in unusable state

Steps to Reproduce


Root Cause

A defect or configuration issue in the operating environment:
The database table pc_assign_worklist was moved to a new table space. The move left the database index in an unusable state. Without an index on this table, the query performance is poor.


Make the following change to the operating environment:
Rebuild the index.

Published September 2, 2016 - Updated September 13, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.