Migration of a table partitioning
Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c. When an “online” clause is specified, all dml operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. No dml operations are allowed if the partition|sub-partition is moved offline. some examples … SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name; Move a table partition|sub-partition to a new tablespace offline. SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name UPDATE INDEXES ONLINE; Move a table partition or sub-partitioning online maintaining any local/global...