ITPub博客

首页 > 数据库 > 数据库开发技术 > Create Index ...ONLINE

Create Index ...ONLINE

原创 数据库开发技术 作者:tsinglee 时间:2007-11-15 10:56:13 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 遇到ORA-12532
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1897772