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的组。