看样子全文索引，还需要定期BUILD

今天有人告诉我数据库上有如下错误：

很明显是全文索引的错误，我接下去做了rebuild ，还不能REBUILD ONLINE，FT～···

 

@>alter index SFA_ACCOUNT_COM_CTXIND rebuild online;

alter index SFA_ACCOUNT_COM_CTXIND rebuild online

*

ERROR at line 1:

ORA-29874: warning in the execution of ODCIINDEXALTER routine

ORA-29960: line 1,

DRG-10595: ALTER INDEX SFA_ACCOUNT_COM_CTXIND failed

DRG-10562: missing alter index parameter

 

 

@>alter index SFA_ACCOUNT_COM_CTXIND rebuild;

Index altered.

 

接下去，一切正常了：

 

查了METALINK：

Bug# 3039404   See Note 3039404.8

      OERI[12406] using NOT CONTAINS with local partitioned TEXT index

      Fixed: 9.2.0.5, 10.1.0.2