Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max Extents reached !!
Hi,
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.
In article <7b3cso$jhm$1_at_nnrp1.dejanews.com>,
ckchai_at_cybertouch.com.my wrote:
> Hi all,
> 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 ?
> I hope someone will respond. Thanks in advance.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 01:53:54 CST