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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Move index to an other table space ?

Re: Move index to an other table space ?

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 02 Mar 2005 10:38:16 -0600
Message-ID: <1109781172.8933bddaafa6b752961fe85612105c67@teranews>


"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

Original text of this message

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