How to move Partition/Subpartition to Different Tablespace
This thread is for discussion and questions about MOVE Partition/Subpartition to different Tablespace.
General Advice:
Below documents will explain the steps required to move a partitioned table to a different tablespace.
How to Move a Partitioned Table To A New Tablespace (Doc ID 1474267.1)
How To Move Partitioned Tables to Another Tablespace When They Contain LOBs (Doc ID 1388957.1)
How to Add a Partition/Subpartition & Move a Partition/Subpartition to Different Tablespace (Doc ID 973776.1)
From 12c, DML are allowed during Online Move Partition. ALTER TABLE MOVE PARTITION becomes non-blocking online DDL. Global indexes and local indexed are maintained during the move partition, so a manual index rebuild is no longer required. The online partitioning movement removes the read-only state for the actual MOVE PARTITION command.