Oracle Error ORA-29928: duplicate default selectivity specified

Oracle Error Message

ORA-29928: duplicate default selectivity specified

Reason for the Error

The keyword DEFAULT SELECTIVITY can only be specified once.

Solution

Remove the duplicate keyword.