My Oracle Support Banner

Troubleshooting Weekly CCS_BE_CDR Database Table Partitions and "ORA-01688: unable to extend table" Error Messages (Doc ID 1304330.1)

Last updated on MAY 20, 2021

Applies to:

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

Purpose

This document provides a high level overview of the Network Charging and Control (NCC)  CCSPART/CCSCPART (ccsCdrPart package) software that is used for splitting database tables into weekly partitions.  There are also various tools and tips given in the document which will assist in debugging the Charging Control Service Partitioning (CCSPART) software.

Notes:
1) Veritas File System (VFS or VxFS) is required for CCSPART in a clustered environment, stand-alone installations don't require VFS.
2) There are various tables which can be used with partitioning software, one of the most popular table is CCS_BE_CDR table and hence used as an example throughout this document.
3) Refer to Note 1353008.1 for troubleshooting non-partitioned CCS_BE_CDR database


As well as giving a high level overview of CCSPART application, the main focus of this document is what to do if the following errors are reported in the syslog (/var/adm/messages).

This will occur when a CCS_BE_CDR weekly partition is full and new Event Data Records (EDR) - previously referred to as CDR (Call Data Records) - can not be inserted into the database.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. What is partitioning?
 2. Partition rolling window
 3. ccsCdrPart partitioning package
 4. Partitioning tasks
 5. Debugging - Tips and Tools
 6. Issue Example: Unable to extend CCS_BE_CDR partition, or delete historical data
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.