今天有人告诉我数据库上有如下错误:
很明显是全文索引的错误,我接下去做了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