Monday, September 7, 2015

ORA-01502 index or partition of such index is in unusable state

The following error appeared on application side while trying to deploy the new SRF on the application, as you see from the above error it's database error and to solve it follow the below steps :-



from database side :-

sqlplus /as sysdba

From the above picture check the index name and put it inside this query :-

select owner,index_name,table_name,status from dba_indexes where index_name='index_name';

OWNER    INDEX_NAME    TABLE_NAME    STATUS
-----    ----------    ----------    ------
owner    index_name     table_name    INVALID

alter index ndex_name rebuild;


Try again

Cheers
Osama 

1 comment: