Oracle Error ORA-38428: too many attributes selected for indexing

Oracle Error Message

ORA-38428: too many attributes selected for indexing

Reason for the Error

An attempt was made to create an expression filter index with more than 490 indexed attributes.

Solution

Remove some of the indexed attributes. Make sure that the default indexed attributes associated with the attribute set combined with the indexed attributes specified in the Create Index Parameters clause are less than or equal to 490.