ORA-14458: attempt was made to create a temporary table with INDEX organization

文档解释

ORA-14458: attempt was made to create a temporary table with INDEX organization

Cause: An attempt was made to create an Index Organized Temporary table. This is not supported.

Action: Create the table with HEAP organization and the primary key.

ORA-14458: 是由于尝试创建一个索引组织的临时表而导致的错误。该错误提示,临时表永远不允许创建为索引组织表,因此不能使用INDEX子句将其定义为索引组织表。

官方解释

ORA-14458:尝试创建INDEX子句定义的索引组织临时表时发生,但尝试失败。临时表永远不能创建为索引组织表,因此不能使用INDEX子句将其定义为索引组织表。

常见案例

ORA-14458错误往往发生在脚本中,如下例:

CREATE GLOBAL TEMPORARY TABLE “global_temp”

(

“a” NUMBER ( 10, 0 ) ,

“b” NUMBER ( 10, 0 )

) ON COMMIT PRESERVE ROWS index

STORAGE ( INITIAL 1 M )

NOPARALLEL;

正常处理方法及步骤

1、检查要创建的表类型,检查是否为临时表;

2、删除索引子句;

3、重新执行SQL脚本;

你可能感兴趣的