Completes Run ALTER TABLEMOVE in parallel for best performance ALTER TABLE MOVE will invalidate any indexes on the partition or table;About Moving Partitions and Subpartitions Use the MOVE PARTITION clause of the ALTER TABLE statement to Recluster data and reduce fragmentation Move a partition to another tablespace Modify createtime attributes Store the data in compressed format using table compression Typically, you can change the physical storage attributes of a partition in a single step using anUse the ALTER TABLE statement to alter the definition of a nonpartitioned table, a partitioned table, a table partition, or a table subpartition For object tables or relational tables with object columns, use ALTER TABLE to convert the table to the latest definition of its referenced type after the type has been altered Partitioning Large Tables Pivotal Greenplum Docs Oracle 12c alter table move partition online parallel
