ORA 01631

[kburrows]

I found this error in my alert log.
Tue Nov 21 07:36:22 2000
ORA-1631: max # extents 249 reached in table ********.*********.

Documentation:
Cause: The maximum amount of space allowed for saving undo entries has
been reached for the named table.
Action: If possible, increase the value of either the MAXEXTENTS or PCTIN-CREASE
initialization parameters.

Which action is better and how would I go about doing these two things.

Thanks in advance
Kathy

[ligang]

if your oracle version is 7.3.3 above , you could
solve this problem by specifiy "unlimited extend "
in the storage option .

However , you'd better export this table (using compress option) and import this table again . Then modify the next ,
pctincrease option.

[kburrows]

Thank you very much,

I took the maxextents unlimited choice. I am going to check into the export option.