In Oracle Database 12c Release 2 (12.2) the and operations on heap tables can be performed online so they don't block DML. This is done by the addition of the keyword, which also causes local and global indexes to be updated without having to specify the clause. - Online SPLIT PARTITION - Online SPLIT SUBPARTITION Related articles. Create a partitioned table with a single partition, along with a global and partitioned index. Display the current table partition and index information. Perform an online operation to split the 2017 partition to create a new partition for rows with a column value in 2015. Display the current status of the table partitions and indexes. Notice both the global and local indexes are left in a usable state without having to specify the clause. For a comparison, perform an offline operation to split the 2017 partition to create a new partition for rows with a column value in 2016. Display the current status of the table partitions and indexes. Notice both the global and local indexes on the affected partitions are left in a unusable state because we didn't specify the clause or keyword. Create a subpartitioned table with two partitions, each with two subpartitions, along with a global and partitioned index. Display the current table partition and index information. Perform an online operation to split the "small" subpartition to create a new partition for rows with a column with values 'TWO' and 'THREE'. Display the current status of the table subpartitions and indexes. Notice both the global and local indexes are left in a usable state without having to specify the clause. For a comparison, perform an offline operation to split the subpartition for the second partition. Display the current status of the table subpartitions and indexes. Notice both the global and local indexes on the affected subpartitions are left in a unusable state because we didn't specify the clause or keyword. For more information see: Hope this helps. Regards Tim...