文档解释 ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW Cause: INCLUDING clause of a CREAT
ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW
Cause: INCLUDING clause of a CREATE TABLE is an valid option only for index-organized tables with OVERFLOW clause (at creation time) or if an OVERFLOW segment already exists (at ALTER time).
Action: Specify OVERFLOW clause for the index-organized table : For ALTER, perfORM ADD OVERFLOW first.
ORA-25186 错误通知用户,INDEX-ORGANIZED表禁止使用 INCLUDING 子句。
RA-25186:(加入子句指定给索引组织表案)
当指定 INCLUDING子句 对 INDEX-ORGANIZED表的时候,会发生ORA-25186错误。INCLUDING 子句是用于索引组织表的 OVERFLOW 子句的一部分。
例如,下面的查询将会引发ORA-25186错误:
CREATE TABLE t1
(id NUMBER(6) PRIMARY KEY,
last_name VARCHAR2(20),
first_name VARCHAR2(15))
ORGANIZATION INDEX
INCLUDING (last_name, first_name);
为解决这个问题,需要从sql语句中删除INCLUDING的子句,因为索引组织表不支持INCLUDING子句:
CREATE TABLE t1
(id NUMBER(6) PRIMARY KEY,
last_name VARCHAR2(20),
first_name VARCHAR2(15))
ORGANIZATION INDEX;
--结束END--
本文标题: ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/538607.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0