My Oracle Support Banner

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

Last updated on MARCH 02, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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