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
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)..??