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 laterInformation 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 |