My Oracle Support Banner

Rebuilding Indexes in a OCNCC (Oracle Communication Network and Charging Control) Database (Doc ID 1328295.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Communications Network Charging and Control - Version 3.2.0 and later
Oracle Communications Convergent Charging Controller - Version 6.0.0 and later
Oracle Solaris on SPARC (64-bit)


This article describes how to determine if rebuilding indexes could be necessary on OCNCC (Oracle Communication Network Charging Control) or OCCCC (Oracle Communications Convergent Charging Controller) products.

It also informs the OCNCC/OCCCC system administrator about the implications of such an operation.


NCC system administrator looking to maintain the indexes used by the NCC application.


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
 A few words on : TableSpace, Data File, Table, Index, Segment, Extent
 Index, B-tree and ... fragmentation ?
 Is Index Fragmentation the right problem ?
 NCC tables and indexes
 Gather information on the table, index and the index tablespace
 Rebuilding the index
 Table Space usage
 List of NCC tables with volatile data

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