Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 10, 2009 at 01:56 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2009 at 01:48 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.