ORA-14045: only one partition may be modified

文档解释

ORA-14045: only one partition may be modified

Cause: ALTER TABLE|INDEX MODIFY PARTITION contained descriptions of more than one partition to be modified

Action: Ensure that the statement describes exactly one partition to be modified and that it does not contain any commas

？

ORA-14045 错误代码表明，你只能同时修改一个分区。

官方解释

ORA-14045: only one partition may be modified Cause: An attempt was made to modify multiple partitions at the same time. Only one partition can be modified at a time. Action: Modify only one partition at a time.

常见案例

要求将多个分区修改为不同的值时，ORA-14045错误会出现。

正常处理方法及步骤

1.使用ALTER TABLE语句单独修改每个分区。

2.尝试使用一个EXCHANGE子句将一组分区替换为其他分区。

3. 尝试使用一个MERGE子句来合并两个分区。