ORA-14175: a subpartition maintenance operation may not be combined with other operations

ORA-14175: a subpartition maintenance operation may not be combined with other operations
Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a subpartition maintenance operation (e.g. MOVE SUBPARTITION) with some other operation (e.g. MODIFY PARTITION ADD SUBPARTITION or PCTFREE) which is illegal
Action: Ensure that a subpartition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with subpartitions, default attributes of partitioned tables/indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14175：子分区维护操作不能与其他操作组合,
.原因： ALTER TABLE或ALTER INDEX语句试图将子分区维护操作（例如MOVE SUBPARTITION）与非法的其他操作（例如修改分区添加子代或PCTFREE）组合在一起,
.操作：确保子分区维护操作是ALTER TABLE或ALTER INDEX语句中指定的唯一操作; 除了那些处理子分区，分区表/索引的默认属性或指定重命名表（ALTER TABLE RENAME）的操作之外的操作可以随意组合,
.

aiaiDBA

13718043309

010-86462881

ORA-14175: a subpartition maintenance operation may not be combined with other operations

1 个回答

相似问题