ORA-14004: missing PARTITION keyword ORACLE 报错 故障修复 远程处理

文档解释

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);


数据运维技术 » ORA-14004: missing PARTITION keyword ORACLE 报错 故障修复 远程处理