Purge Events From partition_historic Partition
Last updated on SEPTEMBER 02, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.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.
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, 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.
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