Need to move table partitions to a different tablespace
Hello Dear experts,
I have a question regarding table partitions move. My environment is below:
10gR2 , 2-node RAC on Solaris 10 (Sun sparc-64 bit) with Veritas VCS
I have a lot of table partitions (range based) with Local indexes in production that I need to move to a different tablespace.
I am aware that this can be accomplished with
ALTER TABLE <table_name> MOVE PARTITION <partition_name> TABLESPACE <new_tablespace_name>;
My questions are :
Do I need to explicitly move the Local Index partitions or would these move automatically?
Would this make any partitioned indexes unsuable?
Would I need to re-build the index partitions in the new tablespace?
I have a question regarding table partitions move. My environment is below:
10gR2 , 2-node RAC on Solaris 10 (Sun sparc-64 bit) with Veritas VCS
I have a lot of table partitions (range based) with Local indexes in production that I need to move to a different tablespace.
I am aware that this can be accomplished with
ALTER TABLE <table_name> MOVE PARTITION <partition_name> TABLESPACE <new_tablespace_name>;
My questions are :
Do I need to explicitly move the Local Index partitions or would these move automatically?
Would this make any partitioned indexes unsuable?
Would I need to re-build the index partitions in the new tablespace?
0