ORA-14185: incorrect physical attribute specified for this index partition ORACLE 报错 故障修复 远程处理

文档解释

ORA-14185: incorrect physical attribute specified for this index partition

Cause: unexpected option was encountered while parsing physical attributes of a local index partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, PCTUSED, LOGGING and TABLESPACE; but only TABLESPACE may be specified for Hash partitions STORE IN () is also disallowed for all but Composite Range partitions

Action: remove invalid option(s) from the list of physical attributes of an index partition

ORA-14185是Oracle数据库提示的一种错误，表示指定的实际属性与指定的索引分区不匹配。

官方解释

常见案例

正常处理方法及步骤

1.检查索引分区的实际属性是否跟Oracle所期望的属性一致。

2.如果实际属性与Oracle所期望的属性不一致，则执行alter index partition重新设置索引分区的属性。该语句的基本形式如下：

alter index partition rebuild

[physical_attributes_clause];

其中physical_attributes_clause 是指定索引分区的相关物理属性。