Re: Rebuild index

wasim_ahmed_at_my-deja.com wrote:
>
> alter index index_name rebuild
> regards,
> Wasim
>
> In article <7prbnl$sbr$1_at_nnrp1.deja.com>,
> wasim_ahmed_at_my-deja.com wrote:
> > In article <687w3.50$di5.273_at_news.get2net.dk>,
> > "Søren Lauritzen" <sorenl_at_rki.dk> wrote:
> > > How to rebuild an index?
> > >
> > > Thanking you in advance.
> > >
> > > Søren

[snip]

But there is a trap, at least in 7.3.4. If you leave out a storage clause, alter index rebuild recreates the index in the default tablespace, which may not be what you want.

--

Phil Singer                     |psinger1_at_livingonline.com(home)
Oracle DBA & Webmaster          |psinger1_at_ford.com (work)

"Now with the wisdom of years, I like to reason things out. And thhe only people I fear are those who never have doubts"

                            ....Billy Joel