Partition_utils Not Dropping The Oldest Partition During The Purging (Doc ID 2756998.1)

Last updated on MAY 15, 2024

Applies to:

Goal

On : 12.0.0.3.0 version, Purging

When executing partition_utils to remove old partitions on EVENT_T table, the oldest partition is not deleted.

The steps to reproduce:

1) select partition_name from ALL_TAB_PARTITIONS where partition_name like ' 15%' and table_name='EVENT_T';
P_D_11012015
P_D_12012015
P_R_11012015
P_R_12012015

2) running partition utils not picking up those partitions (the oldest partitions are not removed)
partition_utils -o remove -c /event -t realtime -s 01012010 -e 01012018 -f
partition_utils -o remove -c /event -t delayed -s 01012010 -e 01012018 -f

3) select partition_name from ALL_TAB_PARTITIONS where partition_name like ' 15%' and table_name='EVENT_T';
P_D_11012015
P_R_11012015

In partition_utils.log it can be seen oldest partitions dropped are P_R_12012015 and P_D_12012015:

Is this expected behavior or a bug?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.