Oracle Error ORA-29822: selectivity cannot be specified for the type of object

Oracle Error Message

ORA-29822: selectivity cannot be specified for the type of object

Reason for the Error

User tried to associate selectivity with index or indextypes which is not allowed .

Solution

Specify a valid option.