I would drop and recreate TEMP with larger initial and next (they should be
the same).
This way, fewer extents would be required. Your problem is probably not a
good
reason (by itself) to require recreation of the database with larger block
size.
Recreate TEMP when no one is using the database.
manager43_at_my-dejanews.com wrote in message
<7b5juf$j78$1_at_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 Sun Feb 28 1999 - 14:36:36 CST
