My Oracle Support Banner

How to Diagnose and Resolve ORA-1628, ORA-1630, ORA-1631, ORA-1632, ORA-1684 : max # of extents <num> reached in < OBJECT > (Doc ID 1025581.6)

Last updated on SEPTEMBER 12, 2023

Applies to:

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

Purpose

 This document can be used to diagnose and resolve space management errors -

ORA-1628, ORA-1630, ORA-1631, ORA-1632 and ORA-1684

You are working with the database and you have encountered one of the following errors:

 

The max extents error occurs when the current number of extents equals the maximum number of extents in the max_extents parameter for the object or the maximum number of extents allowable for the db_block_size , whichever is smaller, and an attempt is made to add another extent.

Max extents can be set for an object using the MAXEXTENTS option of the storage clause.

 

Troubleshooting Steps

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

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

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