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

Oracle 索引 About 323 words

错误原因

索引状态变为了UNUSABLE

解决方法

查看索引状态

SELECT OWNER, INDEX_NAME,STATUS  FROM DBA_INDEXES WHERE INDEX_NAME='INDEX_NAME';
SELECT OWNER, INDEX_NAME,STATUS  FROM ALL_INDEXES WHERE INDEX_NAME='INDEX_NAME';
SELECT  INDEX_NAME,STATUS  FROM USER_INDEXES WHERE INDEX_NAME='INDEX_NAME';

重建索引(生产环境大数据量会比较耗时)

ALTER INDEX INDEX_NAME REBUILD
Views: 3,375 · Posted: 2020-12-02

————        END        ————

Give me a Star, Thanks:)

https://github.com/fendoudebb/LiteNote

扫描下方二维码关注公众号和小程序↓↓↓

扫描下方二维码关注公众号和小程序↓↓↓


Today On History
Browsing Refresh