My Oracle Support Banner

Issue With Index Creation For The Index "D1T447P0" (Doc ID 2541934.1)

Last updated on JULY 05, 2021

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.3.0 and later
Information in this document applies to any platform.

Goal

On : 2.2.0.3.0 version, Database

Confirmation for v2.2.0.3 upgrade


 Upgrade ended with "Process Completed Sucessfully, Now Exiting ...", but the index "D1T447P0" for D1_AGG_MSRMT is not created.
  As User investigated DB after upgrade, primary key of "D1_AGG_MSRMT" is created as "SYS_C0075454".

 

An error occurred for "CREATE UNIQUE INDEX" with the following log message:
  [main] WARN (oem.install.OraSchUpg) Ignorable error occurred while executing SQL: StmtType-C, Stmt-CREATE UNIQUE INDEX D1T447P0 ON D1_AGG_MSRMT(MEASR_COMP_ID,MSRMT_DTTM) INITRANS 2 MAXTRANS 255 PCTFREE 10 TABLESPACE CISTS_01 NOPARALLEL

 

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
References


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