ORA-42018: partition cannot be redefined online because of index organization incompatibility

ORA-42018: partition cannot be redefined online because of index organization incompatibility
Cause: interim table is incompatible with partition being redefined because one or more of the following apply:
- one is index-organized and the other is not

- one has IOT overflow segment and the other does not

- one has IOT mapping table and the other does not

Action: Ensure that the interim table is compatible with the partition being redefined.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-42018：由于索引组织不兼容，无法在线重新定义分区,
.原因：临时表与重新定义的分区不兼容，因为以下一个或多个适用：,
.- 一个是索引组织的，另一个不是,
.,
.- 一个有IOT溢出段，另一个没有,
.,
.- 一个有IOT映射表，另一个没有,
.,
.操作：确保临时表与要重新定义的分区兼容。,
.

aiaiDBA

13718043309

010-86462881

ORA-42018: partition cannot be redefined online because of index organization incompatibility

1 个回答

相似问题