My Oracle Support Banner

ORA-01632: max # extents (<yyy>) reached in index SYS.I_SUMPARTLOG$_BOPART$ Refreshing Materialized View (Doc ID 2977090.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Materialized View refresh refresh fails with:

 

ORA-01632: max # extents (505) reached in index SYS.I_SUMPARTLOG$_BOPART$

<span>select segment_name, extents, max_extents from DBA_SEGMENTS where owner = 'SYS' and SEGMENT_NAME like 'I_SUMPARTLOG%';</span>

<span>SEGMENT_NAME EXTENTS MAX_EXTENTS</span>
<span>I_SUMPARTLOG$ 504 505</span>
<span>I_SUMPARTLOG$_BOPART$ 505 505 </span>

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.