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

Here is a quick script to rebuild all of the problem indexes:

declare

begin

for index_rec in (select owner, index_name

from dba_INDEXES

where status = 'UNUSABLE')

loop

execute immediate 'alter index ' index_rec.owner '.'

index_rec.index_name ' rebuild';

end loop;

end;

مرحبا بكم ,,,

السلام عليكم ,,,

مرحباً بكم فى مدونتي ,,, أتمني لكم الفائدة.