ORA-30554: function-based index string.string is disabled

ORA-30554: function-based index string.string is disabled
Cause: An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed.
Action: Perform one of the following actions: -- drop the specified index using the DROP INDEX command -- rebuild the specified index using the ALTER INDEX REBUILD command -- enable the specified index using the ALTER INDEX ENABLE command -- make the specified index usable using the ALTER INDEX UNUSABLE command

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30554：基于函数的索引字符串。字符串被禁用,
.原因：试图访问已标记为禁用的基于函数的索引，因为索引所依赖的函数已更改。,
.操作：执行以下操作之一： - 使用DROP INDEX命令删除指定的索引 - 使用ALTER INDEX REBUILD命令重建指定的索引 - 使用ALTER INDEX ENABLE命令启用指定的索引 - 使指定的索引可以使用ALTER INDEX UNUSABLE命令,
.

aiaiDBA

13718043309

010-86462881

ORA-30554: function-based index string.string is disabled

1 个回答

相似问题