Question On Purging Of Data (Doc ID 1363556.1)

Last updated on APRIL 28, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 27-May-2013***

Goal

We are planning to purge data in our production system as we need to reuse the storage space. But we found that there are open items, so the partitions that contain events pointing to these items will not be touched.

We tried to call PCM_OP_AR_ITEM_WRITEOFF to write off these open items so that they get closed. However, the problem is that the opcode is taking 2 seconds for each item and we have thousands of such items.

Can  we do the purging with -f option (force removal of partitions) or is there any other way to do this in faster way. Our requirement is to free the storage space as soon as possible.


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