Re: alter index ... rebuild

From: George Leontiadis <gleon_at_dblab.ece.ntua.gr>
Date: Fri, 29 Nov 2002 16:05:47 +0200
Message-ID: <as7s5k$r5v$1@nic.grnet.gr>

Richard Foote wrote:

> "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.
> 

What about a domain index ?

George Received on Fri Nov 29 2002 - 08:05:47 CST