Oracle Error ORA-02478: merge into base segment would overflow MAXEXTENTS limit

Oracle Error Message

ORA-02478: merge into base segment would overflow MAXEXTENTS limit

Reason for the Error

Merge of temporary segment into base segment failed because MAXEXTENTS was larger than the total in the temp and base segments

Solution

Use a larger value for MAXEXTENTS on the base segment or make the extents in the temporary segments larger