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扫描下方二维码关注公众号和小程序↓↓↓
Loading...