ORA-14004: missing PARTITION keyword

文档解释

ORA-14004: missing PARTITION keyword

Cause: keyword PARTITION missing

Action: supply missing keyword

等

Oracle 在创建表分区时，如果缺少PARTITION关键字，就会引发ORA-14004错误。

官方解释

ORA-14004: missing PARTITION keyword

Cause: the SQL statement attempted to create a table partition without a PARTITION keyword.

Action: you must include a PARTITION keyword in the CREATE TABLE statement for all table partitions.

常见案例

/* 此处缺少 PARTITION 关键字 */

CREATE TABLE TEST_PARTITION

(ID NUMBER,

NAME VARCHAR2(20))

PARTITION BY RANGE (ID)

VALUES LESS THAN (100);

正常处理方法及步骤

确保在分区开始的PARTITION BY RANGE 后面，添加PARTITION关键字：

CREATE TABLE TEST_PARTITION

(ID NUMBER,

NAME VARCHAR2(20))

PARTITION BY RANGE (ID)

PARTITION VALUES LESS THAN (100);