You can increase the SORT_AREA_SIZE for that particular session only.
Alter session set SORT_AREA_SIZE= ;
You don't have to change the init.ora just for rebuilding index.
But if index is large , I still prefer dropping and recreating it.
Brijesh
-----Original Message-----
From: james ellis [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: temp problem when rebuilding Index
You can also increase your SORT_AREA_SIZE parameter in
the initDBNAME.ora. This will allow more of your
sorting to be done in memory rather on disk. This will
also help speed up the process.
--- Raghu Kota <[EMAIL PROTECTED]> wrote:
> Hi Friends
>
> Iam rebuilding my 6Gb index, But Iam getting problem
> with TEMP tablespace.
> What is solution for this??
>
> iam using alter index index_name rebuild
> tablespace_name;
>
> ORA-1652: unable to extend temp segment by 128 in
> tablespace TEMP
>
> Any Ideas??
>
> Thanks
> Raghu.
>
_________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Raghu Kota
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: james ellis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
