Re: create large index

From: Daniel <delj_at_flash.net>
Date: 27 Jan 2000 17:57:19 EST
Message-ID: <86qigf$i1@journal.concentric.net>

If it is just a one time thing, try
alter user your_user_name temporary tablespace the_big_data_tablespace; Create your index.
alter user your_user_name temporary tablespace temp;

Daniel
Austin, TX

<jieyuan_at_my-deja.com> wrote in message news:86qfuh$ue6$1_at_nnrp1.deja.com...
> I am creating an index on a large table. I got a
> message said can not allocate more space in TEMP
> tablespace. If I do not want to increase the size
> of TEMP tablespace, what should I do? Can I
> divied the creating index process into two
> processes? Thank you
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 27 2000 - 16:57:19 CST