文档解释
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;
