ORA-14255: table is not partitioned by Range, List, Composite Range or Composite List method

文档解释

ORA-14255: table is not partitioned by Range, List, Composite Range or Composite List method

Cause: The table was not partitioned by Range, List, Composite Range or Composite List method.

Action: ALTER TABLE SPLIT/DROP PARTITION or ALTER TABLE MERGE PARTITIONS command is only valid for table partitioned by Range, List, Composite Range or Composite List methods. Ensure that the table is partitioned appropriately.

ORA-14255:表没有采用范围、列表、复合范围或复合列表方法进行分区

官方解释

常见案例

正常处理方法及步骤

1.通过执行select table_name,partitioning_tyle from user_tables视图,可以查询出当前table是否已经有了分区,如果partitioning_tyle为null或者NONE则表示当前table没有分区。

2.通过执行以下DDL语句分成该table:

CREATE TABLE

(

. . . .

)

PARTITION BY RANGE (coulom_name)

(

PARTITION part_name VALUES LESS THAN (value)

);

3.重新尝试插入数���,此时就不会出现ORA-14255错误。

你可能感兴趣的