Oracle Solution for Error ora-02478

Solution for Oracle Error ORA-02478

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

What triggered the Error:

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

What should we do to fix it:

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