Technical data

D-6 Oracle Utilities Meter Data Management Database Administrator’s Guide
ALTER TABLE D1_MSRMT_LOG ADD CONSTRAINT D1T300P0 PRIMARY KEY
(MEASR_COMP_ID, MSRMT_DTTM, SEQNO) USING INDEX TABLESPACE
<Tablespace_Name>;
CREATE INDEX D1T300S1 ON D1_MSRMT_LOG
(
CHAR_TYPE_CD, CHAR_VAL_FK1
) TABLESPACE <Tablespace_Name> COMPRESS 1;
CREATE INDEX D1T300S2 ON D1_MSRMT_LOG
(
CHAR_TYPE_CD, CHAR_VAL
) TABLESPACE <Tablespace_Name> COMPRESS 1;
CREATE INDEX D1T300S3 ON D1_MSRMT_LOG
(
ORIG_INIT_MSRMT_ID)
TABLESPACE <Tablespace_Name> local COMPRESS 1;
D1_MSRMT_LOG_PARM
CREATE TABLE D1_MSRMT_LOG_PARM
(
MEASR_COMP_ID CHAR(12 BYTE),
MSRMT_DTTM DATE,
SEQNO NUMBER(5,0),
PARM_SEQ NUMBER(3,0),
MSG_PARM_VAL VARCHAR2(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MSG_PARM_TYP_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')),
PARTITION P7 VALUES LESS THAN(TO_DATE('15/03/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS'))