Indexes Incorrectly Created in the USERS Tablespace (Doc ID 1578398.1)

Last updated on OCTOBER 18, 2016

Applies to:

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

Symptoms

Some application database indexes have been incorrectly created in the USERS tablespace on the SMS (Service Management System) and SLC (Service Logic Controller) platform.  It is expected that these application indexes are created in their own specific tablespace.

A simple database query shows the application indexes being stored in the USERS tablespace:

 

Changes

This issue is known from at least 4.4.1.4 (but may have appeared earlier), so an upgrade to 4.4.1.4, or later, may introduce this problem.

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