ONLINE MOVE PARTITION EXAMPLES

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