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);

2 comments:

Anonymous said...

Dear Ramesh, Pls advice for below result
SQL> 1 select OWNER,EXTENTS, MIN_EXTENTS, MAX_EXTENTS from dba_segments where EXTENTS>200
2*

Owner EXTENTS MIN_EXTENTS MAX_EXTENTS
---------- ---------- ----------- -----------
MESMWS 597 1 600
MESMWS 250 1 600

Anonymous said...

Sorry forgot to introduce myself, I'm Budi from Indonesia.

Pls advice how to extent, it said table altered but still the problem persist.

Thanks