ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

文档解释

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;

你可能感兴趣的