Re: Rebuilding large index problem

Your temp tablespace needs to be <at least> as large as your largest table. Indexes are sorted here.
Group bys are sorted here.
Distincts are collected here
yadda yadda (as George would say...)

You can have different "temp" tablespaces for different users.

I have a temp tablespace consisting of two 2G datafiles since my single largest table is just over 3G.
BTW: if your temp tablespace is too small, then I'll bet your rollback segments are too small as well.

Eugene Firyago <efiryago_at_bisys.com> wrote in message news:7vupqe$kas$1_at_autumn.news.rcn.net...
> Try to recreate the index using NOSORT option with CREATE INDEX command to
> avoid sorts using temporary tablespace. It will work if data in this table
> is "presorted". If not, CREATE INDEX ... NOSORT will just fail.
>
> Good luck,
> Eugene.
>
>
> Tony Adolph <tony.adolph_at_viaginterkom.de> wrote in message
> news:7vu6cl$a1n$1_at_nnrp1.deja.com...
> > Hello All,
> >
> > I am trying to rebuild a 2.5 Gbyte index using:
> >
> > alter index <owner>.<index name> rebuild
> > tablespace <new tablespace name> storage (initial <n> M next <n> M);
> >
> > but am running out of TEMP tablespace.
> >
> > The problem is that I do not have very much space to allocate to TEMP.
> > If I drop the index and re-create it rather than using "alter index
> > rebuild..." will I be using TEMP in the same way and hence have the
> > same problem?
> >
> > Thanks for any input,
> > Tony Adolph
> >
> > PS: Ora 7.3.4 on NT4
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Nov 10 1999 - 16:48:17 CST