ORA-39272: Cannot alter organization of nested table column: string

文档解释

ORA-39272: Cannot alter organization of nested table column: string

Cause: DBMS_METADATA_DIFF was comparing two nested table columns. One was a heap table, the other an index-organized table. There is no SQL ALTER statement to change the organization of a nested table.

Action: The difference cannot be eliminated with an SQL ALTER statement.

ORA-39272: Cannot alter organization of nested table column: string是一个错误提示,它表明你正试图对一个嵌套表中的字符串(varchar2或者raw)列进行修改组织,但是而Oracle数据库却不支持这样的操作。

官方解释

常见案例

ALTER TABLE MyTable MODIFY mycolumn ORGANIZATION INDEX;

一般处理方法及步骤

ALTER TABLE MyTable MODIFY mycolumn LONG RAW;

你可能感兴趣的