Purge Events From partition_historic Partition (Doc ID 1272527.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 27-Nov-2012 ***
Checked for relevance on 09-Feb-2016.

Goal

Question 1

There are more than 48 millions records in PARTITION_HISTORIC partition, which is causing  performance issues. There are 2 "old" delayed monthly partitions + current one (one delayed partition has about 20 milions records).

The user would like to purge (export and delete) some of these events. Is it better to delete them from one by one event (sub-)table or to use deletion of event object through testnap?


Question 2

What is the best solution for deleting of events which are already recognized as not needed, but they are placed in not-wanted partition (e.g. PARTITION_HISTORIC). It is understood that it will be needed to change configuration (in order not to have same situation in the future), but this change of configuration will not delete old records.



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms