ORA-64138: Cannot drop groups from an XMLIndex whose internal table has been indexed using Oracle Text. ORACLE 报错 故障修复 远程处理

文档解释

ORA-64138: Cannot drop groups from an XMLIndex whose internal table has been indexed using Oracle Text.

Cause: An attempt was made to drop groups from an XMLIndex whose internal table has been indexed using Oracle Text.

Action: Drop the Oracle Text index on the XMLIndex internal table.

Oracle64138错误表明不允许删除XMLIndex的组，该索引的内部表使用Oracle Text进行索引。

官方解释

常见案例

一般处理方法及步骤

1.如果要删除XMLIndex的组，首先需要把内部表的索引从Oracle Text改为字段索引。

2.要更改后需要使用ALTER INDEX索引更改代码。

3.然后您可以使用DROP GROUPS来删除XMLIndex的组。