ORA-28652: overflow segment attributes cannot be specified

文档解释

ORA-28652: overflow segment attributes cannot be specified

Cause: During ALTER MOVE ONLINE of a index-organized table, the user attempted to enter one or more of the following options: OVERFLOW, PCTTHRESHOLD,INCLUDING.

Action: Remove the illegal option(s).

ORA-28652：溢出段属性不允许是指定的。

官方解释

ORA-28652: overflow segment attributes cannot be specified：This error occurs when the attribute settings for a dictionary managed tablespace’s overflow segments have been specified. It is not legal to specify attributes for overflow segments as they are automatically managed by the database.

常见案例

一般处理方法及步骤

1.删除用于指定溢出段属性的语句，并重新检查代码。

2.从字典管理表空间更改为本地管理表空间。

3.如果第一个步骤无法有效的解决错误，可以使用Oracle支持来解决问题。