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 indexes on the table.

You may also like...

Leave a Reply

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