Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter index ... rebuild

Re: alter index ... rebuild

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 30 Nov 2002 01:01:12 +1000
Message-ID: <4cKF9.86435$g9.243262@newsfeeds.bigpond.com> 





"Marcin Buchwald" <Marcin.Buchwald_at_agora.pl> wrote in message
news:3DE72526.28E198F9_at_agora.pl...


> With the statement

>

> alter index IND_C_MAKIETA_LIB rebuild noreverse tablespace lindx

>

> one can move index to another tablespace.

>

> It doesn't work for a CLUSTER index (ORA-00900)

>

> Can I move a cluster index?




Hi Marc,



Yes you can rebuild a cluster index. In your example, get rid of noreverse.



Cheers



Richard
Received on Fri Nov 29 2002 - 09:01:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US