Oracle DB Error ORA-01632 max # extents (string) reached in index string.string

The following is the cause of this error:

An index tried to extend past MAXEXTENTS.

Action you can take to resolve this issue: If the value of MAXEXTENTS in the index stOracle DB Error ORAge clause is less than the maximum (based on your block size), raise it. Otherwise, re-create the index with larger extent sizes so that the total number of extents falls below the maximum.

Tags: Database, Education, Software

Related