ORA-29928: duplicate default selectivity specified
Cause: The keyword DEFAULT SELECTIVITY can only be specified once.
Action: Remove the duplicate keyword.
ORA-29928: duplicate default selectivity specified错误指示出现了重复的默认选择性指定。
1. 查询v$object_dependency视图了解索引的名称。
2. 使用以下查询查看索引的选择性:
select column_name, SELECTIVITY, DEFAULT_SELECTIVITY
from user_ind_columns where index_name =
‘[name of the index]’
3. 将DEFAULT_SELECTIVITY字段分别更改为“NO”和“CHOOSE”:
update user_ind_columns set DEFAULT_SELECTIVITY = ‘NO’
where index_name = ‘[name_of_the_index]’
and DEFAULT_SELECTIVITY = ‘CHOOSE’;
update user_ind_columns set DEFAULT_SELECTIVITY = ‘CHOOSE’
where index_name = ‘[name_of_the_index]’;
4. 重试更新操作。