My Oracle Support Banner

Purge Events From partition_historic Partition (Doc ID 1272527.1)

Last updated on AUGUST 21, 2018

Applies to:

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

Goal

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?
What is the best solution for deleting of events which are already recognized as not needed?

Note: These 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

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.