Partition Locking

Partition locking improves concurrency and data availability.

Partition locking can be enabled or disabled for user tables. By enabling partition locking, you are locking a partition of interest and therefore allowing access to other partitions for concurrent DDL and DML access options. Concurrent access is allowed for tables during the merge, move, split, and drop partition operations.

Partition locking requires system administrator or database owner permission.