Unusable Index
Problem Statement
ORA-01502: index 'CUSTOM_LOG.PK_LOG_ENTRY_IDX' or partition of such index is in unusable state2025-03-24T19:46:10.856Z WARN --- o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1502, SQLState: 72000
2025-03-24T19:46:10.856Z ERROR --- o.h.engine.jdbc.spi.SqlExceptionHelper : ORA-01502: index 'CUSTOM_LOG.PK_LOG_ENTRY_IDX' or partition of such index is in unusable stateRoot Cause
Resolution: Rebuild the Index
Rebuild the Index
Verification Steps
1. Check Index Status (Non-partitioned or Global Index)
2. If Partitioned, Check Each Partition
Confirm Index Usage in Queries
Last updated