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';