Re: Max Extents reached !!

From: <manager43_at_my-dejanews.com>
Date: Fri, 26 Feb 1999 07:53:54 GMT
Message-ID: <7b5juf$j78$1@nnrp1.dejanews.com>

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