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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02478：合并到基本段将溢出MAXEXTENTS限制,
.原因：将临时段合并到基本段中失败，因为MAXEXTENTS大于临时和基本段中的总数,
.操作：对基段上的MAXEXTENTS使用较大的值，或使临时段中的扩展数据块更大,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题