文档解释 ORA-14110: partitioning column may not be of type ROWID Cause: Partitioning column specified by the user was of typ
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)
);
--结束END--
本文标题: ORA-14110: partitioning column may not be of type ROWID ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/529587.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0