ORA-1631: max # extents 100 reached in table

ORA-1631: max # extents 100 reached in table ICX.ICX_TEXT


SQL> select OWNER, EXTENTS, MIN_EXTENTS, MAX_EXTENTS from dba_segments where segment_name='ICX_TEXT';

OWNER EXTENTS MIN_EXTENTS MAX_EXTENTS
------------------------------ ---------- ----------- -----------
ICX 100 1 100


SQL> select OWNER, EXTENTS, MIN_EXTENTS, MAX_EXTENTS from dba_segments where segment_name='ICX_TEXT';

OWNER EXTENTS MIN_EXTENTS MAX_EXTENTS
------------------------------ ---------- ----------- -----------
ICX 100 1 2147483645



Solutions

ALTER TABLE .table STORAGE ( MAXEXTENTS x);

where x is greater than max_extents and lesser than unlimited (2147483645);

ALTER TABLE ICX.ICX_TEXT STORAGE ( MAXEXTENTS 2147483645);