ORA-42003: partition must be specified for this redefinition ORACLE 报错 故障修复 远程处理

文档解释

ORA-42003: partition must be specified for this redefinition

Cause: A partition was involved in this redefinition but was not specified.

Action: Specify the partition involved in this redefinition.

错误含义：ORA-42003表示在重新定义表时必须指定分区。

官方解释

常见案例

create table test_table (num int)

partition by range(num)

(

partition p1 values less than (10),

partition p2 values less than (20)

);

一般处理方法及步骤

1、执行带有分区定义的SQL语句，重新定义表：

ALTER TABLE test_table

PARTITION BY RANGE(num)

(PARTITION p1 VALUES LESS THAN (10),

PARTITION p2 VALUES LESS THAN (20));

2、确保您正在执行正确的SQL语句，该语句正确定义了各个分区，以正确重新定义表：

SELECT table_name, partition_name, high_value

FROM user_tab_partitions

WHERE table_name = ‘TEST_TABLE’;

3、记得使用COMMIT语句，提交更改。否则，它们将不会被保存。

COMMIT;