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'

 

posted @ 2023-10-16 10:30  雪山上的蒲公英  阅读(78)  评论(0编辑  收藏  举报
/* 返回顶部代码 */