rebuild 索引遭遇ORA-02243

2014-11-24 17:30:59 · 作者: · 浏览: 0

rebuild index 是,rebuild要紧跟索引名后面,在其他选项前面,否则会报错:


SQL> alter index IND_ABC rebuild;


Index altered.


SQL> alter index IND_ABC online rebuild;
alter index IND_ABC online rebuild
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option


online和rebuild调换位置:


SQL>
SQL> alter index IND_ABC rebuild online;


Index altered.