My Oracle Support Banner

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

Last updated on MARCH 19, 2024

Applies to:

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


On : 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



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

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