• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6511
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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