• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6786
  • Last Modified:

ORA-01631 max # extents (505) reached in table ..xyz

ORA-01631 max # extents (505O reached in table ..xyz


Cause: A table tried to extend past MAXEXTENTS.

Action: If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.

What does the 505 mean and if i got them to run the following, would this work >

LTER TABLE DOCUMENT_PART STORAGE (MAXETENTS UNLIMITED);

If that fail try this as this will allow move of storage

ALTER TABLE DOCUMENT_PART MOVE
      STORAGE ( INITIAL 20K
                NEXT 40K
                MINEXTENTS 2
                MAXEXTENTS 20
                PCTINCREASE 0 );

isn't 20k, etc very small amount of storage? should I put in

minextenst 500k, maxextents 800k? would this work? can someone tell me what the above actually means? (move storage)..??

Cheers
E



0
Etravels
Asked:
Etravels
  • 2
  • 2
1 Solution
 
chedgeyCommented:
Try looking at:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses8a.htm#997644

for an explanation of the storage clause.

Only you can say if 20k is a small value. You need to perform a sizing estimate as part of your database design exercise. you need to know how many rows you will be storing, the average row size, the volitility of the data, and the growth rates. Try using Oracle Designer which will calculate your object sizes for you if you enter all of the constraints.

Regards

Chedgey
0
 
chedgeyCommented:
0
 
schwertnerCommented:
MAXEXTENTS 20

do not means 20K.
It means 20 extents each 40k
or 800K approximatelly.



ALTER TABLE DOCUMENT_PART MOVE
     STORAGE ( INITIAL 20K
               NEXT 40K
               MINEXTENTS 2
               MAXEXTENTS UNLIMITED
               PCTINCREASE 0 );
0
 
schwertnerCommented:
ALTER TABLE DOCUMENT_PART STORAGE (MAXEXTENTS UNLIMITED);

should work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now