ORA-14110: partitioning column may not be of type ROWID

文档解释

ORA-14110: partitioning column may not be of type ROWID

Cause: Partitioning column specified by the user was of type ROWID, which is illegal.

Action: Ensure that no partitioning column is of type ROWID.

ORA-14110: partitioning column may not be of type ROWID

官方解释

Oracle 报错 ORA-14110 指示一个非法的PARTITIONING COLUMN,因为它的类型应该是ROWID。

常见案例

ORA-14110通常发生在尝试将某些列声明为分区字段时。例如,如果您试图声明ROWID作为某列的分区字段,那么您将收到ORA-14110。

正常处理方法及步骤

要解决此错误,检查表,确保分区字段列类型不是ROWID,而是其他有效类型(如NUMBER,VARCHAR,DATE等)。例如,以下示例显示如何使用一些有效的类型来定义分区字段:

CREATE TABLE table_name

(

column1 VARCHAR2(20) NOT NULL,

column2 NUMBER NOT NULL,

column3 DATE NOT NULL

)

PARTITION BY RANGE(column2)

(

PARTITION val1 VALUES LESS THAN (100),

PARTITION val2 VALUES LESS THAN (200),

PARTITION val3 VALUES LESS THAN (MAXVALUE)

);

你可能感兴趣的