ORA-14070: option may be specified only for partitioned indices or with REBUILD

ORA-14070: option may be specified only for partitioned indices or with REBUILD
Cause: User issued ALTER INDEX statament containing an option which is legal only for partitioned indices or in conjunction with REBUILD against a non-partitioned index. Such options are: PCTFREE, TABLESPACE, [NO]PARALLEL and INITIAL, FREELISTS, and FREELIST GROUPS inside STORAGE clause
Action: Remove illegal option(s).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14070：选项只能为分区索引或REBUILD指定,
.原因：用户发出ALTER INDEX statament，其中包含仅对分区索引有效的选项，或者与REBUILD结合使用的选项对非分区索引。这些选项是：STORAGE子句中的PCTFREE，TABLESPACE，[NO] PARALLEL和INITIAL，FREELISTS和FREELIST GROUPS,
.操作：删除非法选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-14070: option may be specified only for partitioned indices or with REBUILD

1 个回答

相似问题