JZTXT

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

发布时间 2023-10-16 10:31:53作者: 雪山上的蒲公英
SELECT 'alter index ' ||INDEX_NAME || ' REBUILD;' INDEX_NAME,
INDEX_TYPE,
TABLESPACE_NAME,
TABLE_TYPE,
STATUS
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE'