Technical data

D-2 Oracle Utilities Meter Data Management Database Administrator’s Guide
• D1_INIT_MSRMT_DATA_CHAR
• D1_INIT_MSRMT_DATA_K
• D1_INIT_MSRMT_DATA_LOG
• D1_INIT_MSRMT_DATA_LOG_PARM
D1_MSRMT
CREATE TABLE D1_MSRMT
(
MEASR_COMP_ID CHAR(12 BYTE) NOT NULL ENABLE,
MSRMT_DTTM DATE NOT NULL ENABLE,
BO_STATUS_CD CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MSRMT_COND_FLG CHAR(6 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MSRMT_USE_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MSRMT_LOCAL_DTTM DATE NOT NULL ENABLE,
MSRMT_VAL NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
ORIG_INIT_MSRMT_ID CHAR(14 BYTE) DEFAULT ' ' NOT NULL ENABLE,
PREV_MSRMT_DTTM DATE,
MSRMT_VAL1 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL2 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL3 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL4 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL5 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL6 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL7 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL8 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL9 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
MSRMT_VAL10 NUMBER(16,6) DEFAULT 0 NOT NULL ENABLE,
BUS_OBJ_CD CHAR(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CRE_DTTM DATE NOT NULL ENABLE,
STATUS_UPD_DTTM DATE NOT NULL ENABLE,
USER_EDITED_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE,
VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE
) TABLESPACE <Tablespace_Name>
ENABLE ROW MOVEMENT
PARTITION BY RANGE (MSRMT_DTTM)
SUBPARTITION BY range (MEASR_COMP_ID)
SUBPARTITION TEMPLATE(
subpartition SUB1 values less than (124999999999),
subpartition SUB2 values less than (249999999999),
subpartition SUB3 values less than (374999999999),
subpartition SUB4 values less than (499999999999),
subpartition SUB5 values less than (624999999999),
subpartition SUB6 values less than (744999999999),
subpartition SUB7 values less than (874999999999),
subpartition SUB8 values less than (maxvalue)
)
(PARTITION P1 VALUES LESS THAN(TO_DATE('15/12/2010 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P2 VALUES LESS THAN(TO_DATE('01/01/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P3 VALUES LESS THAN(TO_DATE('15/01/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P4 VALUES LESS THAN(TO_DATE('01/02/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P5 VALUES LESS THAN(TO_DATE('15/02/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P6 VALUES LESS THAN(TO_DATE('01/03/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),