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 laterInformation 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
[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 |