ORA-01631: max # extents (121) reached!!!
360792Jul 13 2006 — edited Jul 13 2006Please review the following DML and error in response of that command:
insert into dtcn (area_code, cons_code, dcdat) values(12,12,sysdate);
ERROR at line 1:
ORA-01631: max # extents (121) reached in table MNBSYS.DTCN
There are only two such tables DTCN and DTCN_HISTORY in which we are unable to insert any record because of above error. Following are some reference information of these tables:
PCT_FREE: 10, PCT_USED: 40 INITIAL_EXTENT: 5242880,
NEXT_EXTENT: 10240, MIN_EXTENTS: 1, MAX_EXTENTS: 121,
PCT_INCREASE: 0, FREELIST: 1, TABLESPACE_NAME: MNB_DATA,
DBUSERNAME: MNBSYS
It may also be noted that the above statistics are exactly same for number of tables but we are facing the problem with only these two tables. Kindly advise what could be the problem and how can I overcome this...
Thanks in anticipation...
Zia Shareef