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

No comments:

Post a Comment

Thanks for your comment.