Oracle DBA, How To, Error, Cause and Action

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

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




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




Action: Try giving a smaller initrans value