Create Index ...ONLINE

Specify ONLINE to indicate that DML operations on the table will be
allowed during creation of the index.

Restrictions on Online Index Building

Online index building is subject to the following restrictions:
■ Parallel DML is not supported during online index building. If you specify
ONLINE and then issue parallel DML statements, then Oracle Database returns an error.
■ You cannot specify ONLINE for a bitmap index or a cluster index.
■ For a nonunique secondary index on an index-organized table, the number of
index key columns plus the number of primary key columns that are included in
the logical rowid in the index-organized table cannot exceed 32. The logical rowid
excludes columns that are part of the index key.

create index ...online字句
指定online则说明当创建该索引的时候dml操作是被允许的

create index ...online字句限定
1. 不支持并行dml ， 否则Oracle将返回一个错误
2. 对于位图索引和簇索引不能指定ONLINE
3. ...

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-982496/