Oracle DBA, How To, Error, Cause and Action

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

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




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




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