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