Troubleshooting Weekly CCS_BE_CDR Database Table Partitions and "ORA-01688: unable to extend table" Error Messages
(Doc ID 1304330.1)
Last updated on DECEMBER 29, 2023
Applies to:
Oracle Communications Network Charging and Control - Version 4.3.0 and laterInformation 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.
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 |