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;