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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:46

ORA-25186：INCLUDING为没有OVERFLOW的索引组织表指定的子句,
.原因： CREATE TABLE的INCLUDING子句仅对于具有OVERFLOW子句（在创建时）的索引组织表或如果OVERFLOW段已存在（在ALTER时间）是有效的选项。,
.操作：为索引组织的表指定OVERFLOW子句：对于ALTER，首先执行ADD OVERFLOW。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题