Monday, September 14, 2009

Quick fix: ORA-01631 max # extents (xxx) reached in table YYYYY

Sympton:

ORA-01631: max # extents (120) reached in table TESTUSER.TEST_TABLE

Quick Fix:

ALTER TABLE TESTUSER.TEST_TABLE STORAGE ( MAXEXTENTS 2147483645 );