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@]