oracle 12cR2 过滤分区维护操作

最新推荐文章于 2023-04-28 00:24:51 发布

地_衣

最新推荐文章于 2023-04-28 00:24:51 发布

阅读量558

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/feixiangtianshi/article/details/78259873

版权

Oracle 12cR2 支持在移动、拆分、合并分区以及转换表时使用过滤条件，仅包含匹配条件的行。本文展示了使用过滤条件进行表和分区维护的实例。

摘要由CSDN通过智能技术生成

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允许在移动、拆分和合并分区，移动表或者将普通表转换为分区表时增加过滤条件。只有满足过滤条件的行在结果对象中。

Filtered Split Partition

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.

该文提供一些使用过滤条件的维护操作的简单示例。本文中的示例主要基于分区维护操作，但该功能同样使用于子分区的维护操作。