rebuild 索引遭遇ORA-02243

来源:互联网 发布:广西教育网络培训网365 编辑:程序博客网 时间:2024/05/21 17:39
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.


0 0