Defragmenting Objects with Alter Shrink Method (ie. After Vouchers Deletion)

(Doc ID 1347102.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Communications Network Charging and Control - Version 3.1.0 and later
Information in this document applies to any platform.

Goal

This document explains how to defragment objects. While this can be applied broadly, this document is particularly focused on OCNCC products family (Oracle Communication Network and Charging Control).

User MUST have Oracle Server Enterprise Edition 10g onwards to be able to apply commands referred in this document (coalesce, shrink), except for the Pre-requisites section (see note).

Some tables and indexes can be fragmented when a huge deletion has been performed as in Doc 1269895.1. This is particularly the case after Vouchers deletion in ccs_voucher_reference and be_vouchers. After this operation, the tablespace usage has not decreased due to fragmentation.

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