
ONLINE MOVE PARTITION EXAMPLES
SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE;
Table altered
SQL> ALTER TABLE test1 MOVE PARTITION
test1_PART1 ONLINE UPDATE INDEXES;
Table altered
SQL> ALTER TABLE test1 MOVE PARTITION
test1_PART1 ONLINE UPDATE GLOBAL INDEXES;
Table altered
Source: Oracle