Create Index ...ONLINE

最新推荐文章于 2025-05-30 09:22:14 发布

转载最新推荐文章于 2025-05-30 09:22:14 发布 · 232 阅读

文章标签：

#git #数据库

本文介绍了在Oracle数据库中使用在线索引创建功能时所受到的各种限制条件，包括不支持并行DML操作、不可用于位图索引或簇索引等，并详细解释了这些限制的具体含义。

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/