-
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
-
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.
-
Thank you very much,
I took the maxextents unlimited choice. I am going to check into the export option.
