Alter Table MERGE Partitions Online Blocks DML Statements
(Doc ID 2735199.1)
Last updated on DECEMBER 18, 2020
Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later Information in this document applies to any platform.
Beginning in Oracle Database 18c, specify the ONLINE keyword with the ALTER TABLE MERGE PARTITIONS (or SUBPARTITIONS) statement to enable online merge operations for regular (heap-organized) tables, while allowing for concurrent DML operations
DML statements are blocked for a short time (even as much as one minute) on the wait event, 'library cache lock'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!