ORA-08121: Number of indexes need to be maintained offline exceeds limit for DML

ORA-08121: Number of indexes need to be maintained offline exceeds limit for DML




Cause: Too many indexes needed to be maintained. The limit is 2^16 indexes for each DML statement




Action: Make sure the index maintainance is online. If indexes need to be maintained offline, drop some indexes.