Oracle Error ORA-08119: The new initrans will make the index too big

Oracle Error Message

ORA-08119: The new initrans will make the index too big

Reason for the Error

Specifying the initrans need additional space to hold the index key which might make the index too big

Solution

Try giving a smaller initrans value