ORA-14020: this physical attribute may not be specified for a table partition

ORA-14020: this physical attribute may not be specified for a table partition
Cause: unexpected option was encountered while parsing physical attributes of a table partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, and PCTUSED; only TABLESPACE may be specified for Hash partitions
Action: remove invalid option(s) from the list of physical attributes of a table partition

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:41

ORA-14020：可以不为表分区指定此物理属性,
.原因：解析表分区的物理属性时遇到意外的选项; 范围或复合范围分区的有效选项是INITRANS，MAXTRANS，TABLESPACE，STORAGE，PCTFREE和PCTUSED; 只能为Hash分区指定TABLESPACE,
.操作：从表分区的物理属性列表中删除无效选项,
.

aiaiDBA

13718043309

010-86462881

ORA-14020: this physical attribute may not be specified for a table partition

1 个回答

相似问题