My Oracle Support Banner

How to Delete Large Vouchers Batches Through SQL Operations (Doc ID 1269895.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Oracle Communications Convergent Charging Controller - Version 6.0.0 and later
Information in this document applies to any platform.

Goal

This article will explain a method of deleting a large batch of vouchers (that can not be deleted using the Service Management System (SMS)) screens in a safe manner which will have as little impact on a production system as possible.

This method is applicable to all versions of Oracle Communications Network Charging and Control (OCNCC or NCC) and Oracle Communications Convergent Charging Controller (OC3C).

It is not recommended to delete large vouchers batches as it has an impact on replication load and can cause service degradation, all nodes are hit with lots of updates (well deletes) at the same time.

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.