ORA-28667: USING INDEX option not allowed for the primary key of an IOT

ORA-28667: USING INDEX option not allowed for the primary key of an IOT
Cause: User attempted to define storage attributes for the primary key index of an Index-Organized table with USING INDEX clause. All the storage attribute defined for the (IOT)table applies to the primary key index and a separate USING INDEX clause is not required.
Action: Remove the USING INDEX clause and specify all attributes directly for the table

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28667：对于IOT的主键不允许使用INDEX选项,
.原因：用户尝试使用USING INDEX子句定义索引组织表的主键索引的存储属性。为（IOT）表定义的所有存储属性适用于主键索引，不需要单独的USING INDEX子句。,
.操作：删除USING INDEX子句并直接为表指定所有属性,
.

aiaiDBA

13718043309

010-86462881

ORA-28667: USING INDEX option not allowed for the primary key of an IOT

1 个回答

相似问题