Split partition online(12cR2 only) - Oracle Database Script. SQL> ALTER TABLE order_tab split PARTITION CREATED_MX INTO (PARTITION CREATED_2106_P2 VALUES LESS THAN (TO_DATE('01/03/2016', 'DD/MM/YYYY')),PARTITION CREATED_MX) ONLINE; TABLE altered. SQL> SELECT partition_name, read_only, high_value FROM dba_tab_partitions WHERE TABLE_NAME='ORDER_TAB';
SQL> ALTER TABLE order_tab split PARTITION CREATED_MX INTO (PARTITION CREATED_2106_P2 VALUES LESS THAN (TO_DATE('01/03/2016', 'DD/MM/YYYY')),PARTITION CREATED_MX) ONLINE; TABLE altered. SQL> SELECT partition_name, read_only, high_value FROM dba_tab_partitions WHERE TABLE_NAME='ORDER_TAB';