Error with code : ORA-01631: max # extents (300) reached in table

[Former Member]

Hi

I have a problem with one of the ztables i have created and transported from development to quality. The value in the parameter MAXIMUM_EXTENTS is 300 in quality server and UNLIMITED in the development server. I am getting a short dump when i try to load more than 10000 records in the QA server. can any one please help me with steps i need to do to change the paramer MAXIMUM_EXTENTS to unlimited in qaulity server.

Regards

Yatin Thakkar

[former_member204746 · Accepted solution]

permanent solution: convert your tablespace to locally managed tablespace with ASSM. read SAP note 646681.

until then, go into SE14 and check STORAGE PARAMETERS

click on F5 to go in CHANGE mode

change MAXIMUM EXTENTS to 505

change NEXT EXTENT to a much higher value such as 10240.

good luck.

[stefan_koehler]

Hello Yatin,

here we go ...

shell> sqlplus / as sysdba
SQL> alter table <TABLE> storage (maxextents unlimited);

The value for MAXEXTENTS is stored in the SAP DDIC table TGORA. For more information - please check sapnote #666061

Regards

Stefan