ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition

ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
Cause: Attempted to specify SUBPARTITIONS clause on table that is not partitioned by the Composite Range-Hash method
Action: Reissue the command after ensuring that the SUBPARTITIONS clause is not specified, to specify a template for a Composite Range List object use the SUBPARTITION TEMPLATE clause

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14639：SUBPARTITIONS子句只能为Hash，Composite Range Hash表/分区指定,
.原因：尝试在未由Composite Range-Hash方法分区的表上指定SUBPARTITIONS子句,
.操作：在确保未指定SUBPARTITIONS子句后重新发出命令，以使用SUBPARTITION TEMPLATE子句为复合范围列表对象指定模板,
.

aiaiDBA

13718043309

010-86462881

ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition

1 个回答

相似问题