SAP Note 11777 - ORA-1632 max # extents reached in index

Symptom

ORA1632 max # extents reached in index
--> Index reached the maximum number of extents; further growth is
not possible.

Cause and prerequisites

Storage parameters are too small.

Solution

Change the storage parameters NEXT and MAXEXTENTS:

a) SOLUTION USING SAPDBA:

SAPDBA: -> Reorganization
-> Alter/show table or index storage parameters

- Enter the index name ().
- Start.
The ACTUAL values of storage parameters, the SAPDBA default
values, and the TARGET values are display. Set the TARGET
value of MAXEXTENT to a value that lies a good deal above the
ACTUAL value.
In addition, increase the value for NEXT such that the
number of extents does not increase too quickly, depending on
the expected new data volume.

b) SOLUTION USING SQLPLUS.

SQL> SELECT NEXT_EXTENT,MAX_EXTENTS FROM USER_INDEXES

WHERE INDEX_NAME = '';

SQL> ALTER INDEX STORAGE (NEXT

MAXEXTENTS );

You must specify in upper-case letters.

-> Reorganize table or index

Key word: ORA-1632