Upgrading from Oracle Utilities Meter Data Management V2.5.0.1.0 to V2.5.0.1.1
New Columns
Table_Name
Column_Name
Data Type
D1_DYN_OPT_EVENT
DYN_OPT_EXT_ID_VALUE
VARCHAR2(120)
D1_DYN_OPT_TYPE
DYN_OPT_CATEGORY
VARCHAR2(254)
D1_DYN_OPT_TYPE
DEVICE_REQD_FLG
CHAR(4)
D1_EVT_PARTICIPATION
RESERVATION_START_DTTM
DATE
D1_EVT_PARTICIPATION
RESERVATION_END_DTTM
DATE
D1_EVT_PARTICIPATION
ILM_DT
DATE
D1_EVT_PARTICIPATION
ILM_ARCH_SW
CHAR(1)
D1_SP
D1_INSTALL_DT
DATE
Deleted Columns
Table_Name
Column_Name
Data Type
D1_EVT_PARTICIPATION
EFF_DTTM
DATE
New Indexes
Table_Name
Index_Name
D1_GTT4
D1T407P0
D1_GTT7
D1T554P0
D1_GTT8
D1T555P0
D1_EVT_PARTICIPATION
D1T652S1
D1_EVT_PARTICIPATION
D1T639S2
D1_EVT_PARTICIPATION
D1T639S3
Deleted Indexes
Table_Name
Index_Name
D1_GTT4
D1T407S0
D1_GTT7
D1T554S0
D1_GTT8
D1T555S0