It is possible to move Oracle index to another tablespace.

By inanme

It is possible to move oracle index like tables.

alter table tab move tablespace blabla;
alter index tab_index rebuild tablespace blala;

One Response to “It is possible to move Oracle index to another tablespace.”

  1. H.Tonguç Yılmaz Says:

    Also can be done online – nologging and parallel :)
    http://tonguc.wordpress.com/2007/01/12/technology-changes-very-fast-keep-unlearning/

Leave a Reply