oracle使得index变成不可用状态

oracle使得index变成不可用状态：

ALTER INDEX index_name UNUSABLE;

执行成功后，如果后期需要用到该索引的话，必须重建。重建后自动变成usable状态

 

 

另外，数据库还有2个种修改index状态叫 enable和disable：

ALTER INDEX index_name ENABLE;

ALTER INDEX index_name DISABLE;

2者之间的区别： enable和disable仅仅是针对函数索引

ENABLE applies only to a function-based index that has been disabled because a user-defined function used by the index was dropped or replaced. This clause enables such an index if these conditions are true:

• The function is currently valid

• The signature of the current function matches the signature of the function when the index was created

• The function is currently marked as DETERMINISTIC

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8111049/viewspace-662962/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8111049/viewspace-662962/