ORA-39272: Cannot alter organization of nested table column: string ORACLE 报错 故障修复 远程处理

文档解释

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;