ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index ORACLE 报错 故障修复 远程处理
文档解释
ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index
Cause: User attempted to either drop, split, add or coalesce a partition or a subpartition of a local index which is illegal.
Action: Ensure that the index named in such statement is a global partitioned index.
这个错误表示对本地分区索引提交了无效的修改分区/子分区操作。
官方解释
常见案例
ALTER INDEX p_idx1
SPLIT PARTITION p1 AT VALUES (100)
INTO (PARTITION p2, PARTITION p3);