How to move a partitionated index to another tablespace

Change the index’s default tablespace, so it’ll create every new partition on the new tablespace:
ALTER INDEX <index_name> MODIFY DEFAULT ATTRIBUTES TABLESPACE <new_tablespace>;

Move the index’s partition to another tablespace:
ALTER INDEX <index_name> REBUILD PARTITION <partition_name> TABLESPACE <new_tablespace> NOLOGGING;

Leave a Reply

Your email address will not be published. Required fields are marked *