My Oracle Support Banner

UIM CN | UIM Tables Are Created In SYSTEM Tablespace (Doc ID 2971890.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Communications Unified Inventory Management - Version 7.5.0.2.0 and later
Information in this document applies to any platform.

Symptoms

 UIM -CN |  INSTALLATION Database Issue

==============================

In  UIM CN installation changes to Table Space Name in Project-Spec file are not reflected in database and SYSTEM tablespace was used for UIM tables. We used the below SQL to identify the issue.

SELCT COUNT(1) ,TABLESPACE_NAME 

FROM DBA_TABLES

WHERE OWNER='UIMSCHEMAUSER' GROUP BY TABLESPACE_NAME;

 

OUTPUT:

 

COUNT(1)  |  TABLESPACE_NAME

=====================

   441        |      SYSTEM

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
Cause
Solution
References


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