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

查找出失效索引，然后放入对应的用户库中执行

 

SELECT 'alter index ' ||INDEX_NAME || ' REBUILD;' INDEX_NAME,
INDEX_TYPE,
TABLESPACE_NAME,
TABLE_TYPE,
STATUS
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE'