Re: Move index to an other table space ?

"Mike Stiller" <donotanswer_at_web.com> wrote:

>Hi,
>is it possible to move an index to an other tablespace with sql command?
>
>I found something for tables (ALTER TABLE <tablename> MOVE TABLESPACE
><tablespace name> )
>I need the same for index.
>Can anybody help me ?
>

A quick ( very quick) look at the docs reveals:

Alter index index_name rebuild tablespace 'newtablespacename';

May be what you want. Received on Wed Mar 02 2005 - 10:38:16 CST