Etravels
asked on
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
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
Sorry, pasted the wrong link. Look at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses9a.htm#78017
Regards
Chedgey
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses9a.htm#78017
Regards
Chedgey
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 );
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 );
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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