CCS_RES_LMT_ACCT_PREFIX_UQ Index Located in USERS Tablespace

(Doc ID 2087422.1)

Last updated on DECEMBER 23, 2015

Applies to:

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

Symptoms

On Oracle Communications Network Charging and Control (NCC) release version 5.0.2, the CCS_RES_LMT_ACCT_PREFIX_UQ Index is erroneously installed in the USERS tablespace:

SQL> select OWNER,INDEX_NAME,INDEX_TYPE,TABLE_OWNER,TABLE_NAME,TABLE_TYPE,UNIQUENESS from dba_indexes where INDEX_NAME='CCS_RES_LMT_ACCT_PREFIX_UQ';

OWNER                          INDEX_NAME                     INDEX_TYPE                  TABLE_OWNER                    TABLE_NAME                     TABLE_TYPE  UNIQUENES
------------------------------ ------------------------------ --------------------------- ------------------------------ ------------------------------ ----------- ---------
CCS_ADMIN                      CCS_RES_LMT_ACCT_PREFIX_UQ     NORMAL                      CCS_ADMIN                      CCS_RESOURCE_LIMITATION        TABLE       UNIQUE



SQL> select OWNER, SEGMENT_NAME, TABLESPACE_NAME, SEGMENT_TYPE  from dba_segments where SEGMENT_NAME='CCS_RES_LMT_ACCT_PREFIX_UQ';

OWNER                          SEGMENT_NAME                                                                      TABLESPACE_NAME                SEGMENT_TYPE
------------------------------ --------------------------------------------------------------------------------- ------------------------------ ------------------
CCS_ADMIN                      CCS_RES_LMT_ACCT_PREFIX_UQ                                                        USERS                          INDEX

The above index should be installed in the CCS_INDEX tablespace.

Changes

Upgrade to or installation of NCC 5.0.2.

Cause

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