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

Oracle Error Message

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

Reason for the Error

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

Solution

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