Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |