My Oracle Support Banner

Upgrade Process in UIM for Custom Indexes. (Doc ID 2443024.1)

Last updated on OCTOBER 30, 2022

Applies to:

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

Goal

Below is the SQL for index on LogicalDevice_Char table in UIM 7.2.4 for one of the customer, and the index is identified as missing after upgrading from UIM 7.2.4 to 7.3.5.

CREATE INDEX "I_LGCLCHR_VALUE_CUSTOM" ON "LOGICALDEVICE_CHAR" ("VALUE") parallel 32 nologging tablespace LARGE_INDEX;
 

Solution

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
Goal
Solution


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