Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max Extents reached !!
Do like this
alter tablespace temp default storage (next <size> maxextents unlimited)
ckchai_at_cybertouch.com.my wrote in message
<7b3cso$jhm$1_at_nnrp1.dejanews.com>...
>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
Received on Thu Feb 25 1999 - 06:08:20 CST