ORA-30344: number of child cols different from number of parent level cols ORACLE 报错 故障修复 远程处理

文档解释

ORA-30344: number of child cols different from number of parent level cols

Cause: The number of child columns specified in a JOIN KEY clause is not the same as the number of columns in the specified parent level.

Action: Check the child columns and the columns in the definition of the referenced parent level and correct the discrepency.

ORA-30344 错误指出，使用二级分区表结构定义时，子表级别要求与父表级别列数不一致。

官方解释

ORA-30344: number of child cols different from number of parent level cols

被定义的子表的级别的列数必须与父表的级别的列数完全一致。

例子：

父表定义：

CREATE TABLE PARENT_TABLE (

ID NUMBER,

CUSTOMER_ID NUMBER,

SEQ NUMBER

);

子表：

CREATE TABLE CHILD_TABLE (

ID NUMBER,

CUSTOMER_ID NUMBER

);

在这种情况下，查询：

ALTER TABLE CHILD_TABLE

partition by range (CUSTOMER_ID)

subpartition by list (SEQ)

(PARTITION P1 VALUES LESS THAN (10)

(SUBPARTITION P1S1 VALUES (1), P1S2 VALUES (2)));

就会产生ORA-30344:number of child cols different from number of parent level cols 错误。这是因为子表没有定义SEQ列，而父表却定义了该列。

一般处理方法及步骤

1.确保子表的列数与父表的级别的列数完全一致。

2.如果必须使用部分不同的列，则可以将记录放入null空间，以使子表与父表列数一致：

ALTER TABLE CHILD_TABLE

partition by range (CUSTOMER_ID)

subpartition by list (SEQ)

(PARTITION P1 VALUES LESS THAN (10)

(SUBPARTITION P1S1 VALUES (1, NULL), P1S2 VALUES (2, NULL) );