My Oracle Support Banner

Indexes Installed In DATA Tablespaces Instead of INDEX Tablespaces (Doc ID 1522952.1)

Last updated on SEPTEMBER 17, 2018

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.0 to 5.0.1 [Release 5.0]
Information in this document applies to any platform.

Symptoms

The Network Charging and Control (NCC) installation incorrectly places unique and primary key indexes for ACS (Advanced Control Services), RCA (Radius Control Agent) and UPC (USSD Gateway Portal Component) into their DATA tablespace instead of their INDEX tablespace. 

smf_oper@sms01:~$ sqlplus /

set pages 200 lines 132
col owner format a10
col index_type format a25
col index_name format a30
col tablespace_name format a30

SQL> SELECT
 owner, index_name, index_type, tablespace_name
FROM
 all_indexes
WHERE
 tablespace_name LIKE '%DATA%'
AND
 index_type = 'NORMAL';

OWNER      INDEX_NAME                     INDEX_TYPE                TABLESPACE_NAME
---------- ------------------------------ ------------------------- ------------------------------
ACS_ADMIN  ACS_SUB_TYPE_NAME_UQ           NORMAL                    ACS_DATA
SMF        RCA_ADDRESS_LIST_ENTRY__PK     NORMAL                    RCA_DATA
SMF        UPC_MSG_CLASS__PK              NORMAL                    UPC_DATA

SQL>

This is a minor issue that causes no adverse affects.

Note: A similar issue involving USERS tablespace is documented under <note 1578398.1> - Indexes Incorrectly Created in the USERS Tablespace.

Changes

The ACS index issue was introduced in the NCC 5.0.0.1 (Intrepid Patch set 1) release.

Cause

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
Symptoms
Changes
Cause
Solution
 Workaround
References


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