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