How to solve Max Extents reached
problem?
I have an Oracle 7.3.2 Database which has reached Max Extents ( 121
) for the
tablespace TEMP.
I know I can set the maxextents to unlimited or I can increase the
initial and
next extents.
I'm not very experienced in Oracle, so can anyone give me the commands
to
actually increase the maxextents, initial or next extents ?
Ans1:
Do like this alter tablespace temp default storage (next <size>
maxextents unlimited)
Ans2:
Quantity of maxextents is relate to dababase block size and equal
2K - 121
4K - 249
etc.
Vladimir
P.S. Please note that change database block size only possible via database
creation (recreate database) so store all data firstly.