Filtered Partition Maintenance Operations in Oracle Database 12c Release 2 (12.2)
Oracle Database 12c Release 2 (12.2) allows you to add a filter condition when you move, split or merge a partition, move a table or convert a non-partitioned table to a partitioned table. Only those rows matching the filter condition are included in the resulting object.
Oracle 12cR2允许在移动、拆分和合并分区,移动表或者将普通表转换为分区表时增加过滤条件。只有满足过滤条件的行在结果对象中。
The filter condition is only allowed on heap tables, can only reference columns from the table and can be used in conjunction with online operations with some additional considerations.
过滤条件仅允许在堆组织表上使用,只能引用表中的列及结合一些在线操作的额外条件。
This article provides some simple examples using filter conditions with maintenance operations. The examples in this article are mostly based on partition management operations, but this functionality applies equally to subpartition maintenance operations.
该文提供一些使用过滤条件的维护操作的简单示例。本文中的示例主要基于分区维护操作,但该功能同样使用于子分区的维护操作。
- Move a Table 移动表
- Convert a Non-Partitioned Table to a Partitioned Table 非分区表转换为分区表
- Move a Partition 移动分区
- Split a Partition 拆分分区
- Merge Partitions 合并分区
Related articles.